Sources and Targets
This section describes new sources and targets features in version 9.6.1.
Informatica Sources and Targets
This section describes new features of sources and targets in Informatica.
HAWQ Connectivity
You can use ODBC to read data from and write data to a HAWQ database.
For more information, see the Informatica 9.6.1 Developer Tool Guide.
Data Types
- Microsoft SQL Server Uniqueidentifier Data Type
Informatica Developer supports the Microsoft SQL Server Uniqueidentifier data type. The Uniqueidentifier data type has a precision of 38 and a scale of 0.
For more information, see the Informatica 9.6.1 Developer Tool Guide.
- Oracle Float Data Type
Informatica Developer supports the Oracle float data type. The float data type has a precision of 1 to 15 and a scale of 0.
For more information, see the Informatica 9.6.1 Developer Tool Guide.
PowerCenter Sources and Targets
This section describes new features of sources and targets in PowerCenter.
Oracle Sources and Targets
You can import Oracle sources and targets that use basic compression and OLTP compression. You can also manually create source and target definitions for Oracle tables that use basic compression and OLTP compression.
For more information, see the PowerCenter 9.6.1 Designer Guide.