includes the following new features and enhancements.
Configurations for assessment and conversion
You can create the following configurations from the
Configurations
page and use them in assessment and conversion tasks:
Repoint Configuration
Contains the repoint configuration for assessment. You can use this configuration in assessment tasks to evaluate the feasibility of repointing the assets to another endpoint.
Connection Map
Contains mappings between the PowerCenter connections and the corresponding cloud connections. You can use this configuration in conversion tasks.
Conversion Properties
Contains basic and advanced conversion properties. You can use this configuration in conversion tasks to override the default conversion behavior.
PowerCenter parameter file conversion
You can convert PowerCenter parameter files to
Data Integration
parameter files. Create a
Parameter File Conversion Task
from the
Repositories
page, view and run the job from the
Parameter File Conversion Tasks
page, and monitor the status of the job on the
My Jobs
page.
Session-specific connection types
You can configure a new conversion property,
overrideToSessionConnectionType
to set the source or target connection type as per the session specific connection type. This flag applies to non-repointing scenarios when the source or target uses a different relational database than the session-level connection type.
Native precision and scale for repointing scenarios
You can configure a new conversion property,
UseDsqPrecisionAndScale
to set the native precision and scale for string data type as per the source qualifier. You can set this property when you repoint to any one of the following endpoints:
Google BigQuery
Amazon Redshift
PostgreSQL
Databricks
Snowflake
Azure Synapse
Native precision and scale for non-repointing scenarios
You can configure a new conversion property,
SrcNativeFieldsBasedOnSQFields
to set the native precision and scale for string, decimal, and date time data types based on the source qualifier. This flag applies to non-repointing scenarios for the following connections: