Informatica Developer
This section describes changes to the Developer tool in version 10.0.
Application Deployment Changes
This section describes changes to application deployment in version 10.0.
Retain State Information Check Box
Effective in Informatica 10.0, when you redeploy an application, the “Retain state information” check box allows you to choose to retain the current state of run-time objects that are part of the deployed application. The state refers to mapping properties and the properties of run-time objects such as Sequence Generator Transformations.
Previously, the Deploy dialog box gave you a choice of “Update” or “Replace.” The “Retain state information” check box replaces the “Update” check box, and is selected by default.
If you select "Retain state information," you retain run-time settings and properties in the deployed application. If you clear “Retain state information,” you discard the state of these settings and properties in the deployed application.
Flat File Data Objects
Effective in version 10.0, you configure all of the format and run-time properties for a flat file data object in the Advanced view. The Advanced view contains property sections that you can collapse and expand. The column format sections that display depend on whether you configure a delimited or fixed-width column format.
The following image shows the property sections in the Advanced view:
Previously, you configured the format and run-time properties for a flat file data object in the Read and Write views. In the Read view, you selected the source transformation to configure format properties. You selected the Output transformation to configure run-time properties. In the Write view, you selected the Input transformation to configure run-time properties. You selected the target transformation to configure format properties.
Microsoft SQL Server Changes
Effective in Informatica 10.0, Microsoft SQL Server contains the following changes:
- •You can use the ODBC connection type to connect to Microsoft SQL Server.
- •You can upgrade your existing connections by using the pmrep and infacmd commands. When you run the upgrade command, all the existing connections are upgraded.
- •The existing Microsoft SQL Server connection is deprecated and support will be dropped in the next major release. You can run the existing mappings without manual updates. If you are using SSL connections, you must select the provider type as ODBC in the connection, and configure SSL in the DSN.
Logical Data Object Editing
This section describes changes to the ways you edit logical data objects in the Developer tool in version 10.0.
Logical Data Object and Logical Data Object Model Editors
Effective in Informatica 10.0, you edit logical data objects and logical data object models in separate editors.
Previously, you used the same editor to edit logical data objects and logical data object models.
For more information, see "Logical View of Data" chapter in the Informatica 10.0 Developer Tool Guide.
Logical Data Object Mappings
Effective in Informatica 10.0, you create logical data object mappings from the logical data object editor. Click the Add button to add a read mapping or a write mapping for the logical data object.
Previously, you clicked File > New to create logical data object mappings.
For more information, see "Logical View of Data" chapter in the Informatica 10.0 Developer Tool Guide.
Pushdown Optimization for ODBC Sources and Targets
Effective in version 10.0, support for pushdown optimization to ODBC sources and targets is deprecated.
