PowerCenter Modernization

Back Next

Bulk Metadata Update

Update the metadata of multiple assets in a single operation.

After you convert and migrate the PowerCenter or Data Engineering Integration assets to Data Integration, you can update the metadata of the assets to ensure that the assets function seamlessly in the cloud environment. You can create bulk update tasks to update the metadata of mapping and taskflow asset types.

The bulk update process also generates a comprehensive report that includes a list of assets that are submitted for update and the metadata update status.

Mapping asset metadata

The following table describes the metadata types and the corresponding details you can update using a bulk update task:

Metadata Type	Details
Field details	Field name, native type, precision, scale, platform type, default value, and expression.
Advanced properties	Value of mapping properties.
Connection details	Object name, multiple matches, filter, truncate, lookup condition, and data driven condition.
In-out parameters	Description, data type, precision, scale, expression variable, default value, retention policy, and aggregation type.
Mapping SQL queries	SQL queries of the assets.

Taskflow asset metadata

The following table describes the task types and the corresponding details you can update using a bulk update task:

Task Type	Details
Assignment task	Field, type, and value.
Command task	Type and value.
Data task	Preference to suspend taskflow execution when a warning, error, or failure is encountered or when the data task is not run.
Decision task	Field, condition, and value.
Email task	Input type and value of the subject, content, body, to, and cc parameters.

Mapping task asset metadata

The following table describes the metadata types and the corresponding details you can update using a bulk update task:

Metadata Type	Details
General properties	Description, Verbose, Schedule ID, Mapping Id, Pre-Processing Commands, Post-Processing Commands, Error Emails, Success Emails, Warning Emails, Max Logs, Enable Cross Schema Pushdown, Allow The Mapping Task To Be Executed Simultaneously, Auto Tuned Applied, Auto Tuned Applied Type, $Source Connection Value, $Target Connection Value, Additional Concurrent Pipelines For Lookup Cache Creation, Allow Pushdown For User Incompatible Connections, Create Temporary Sequence, Create Temporary View, Cache LOOKUP() Function, Commit Interval, Commit On End Of File, Commit Type, Constraint Based Load Ordering, Custom Properties, DTM Buffer Size, Data Column Delimiter, Date Time Format String, Default Buffer Block Size, Error Log File Name, Error Log Type, Incremental Aggregation, Java Classpath, Line Sequential Buffer Length, Log Row Data, Log Source Row Data, Maximum Memory Allowed For Auto Memory Attributes, Maximum Percentage Of Total Memory Allowed For Auto Memory Attributes, On Pre-Post SQL Error, On Pre-session Command Task Error, On Stored Procedure Error, Override Tracing, Pre 85 Timestamp Compatibility, Pushdown Optimization, Rollback Transactions On Errors, Session Log File Name, Session Log File Directory, Session Sort Order, Session Retry On Deadlock, Stop On Errors, Treat Source Rows As, Write Backward Compatible Session Log File, Allow Pushdown Across Databases, Enable High Precision, Error Log File Directory, Output File Directory, Pre-build Lookup Cache, Recovery Strategy, Reinitialize Aggregate Cache, Parameter File Name, Parameter File Dir, Param File Type, Param File Connection Id, Agent Id, Runtime Environment, Short Description, and Source File Directory.
Source transformation advanced properties	Value of the advanced properties of the source transformations.
Target transformation advanced properties	Value of the advanced properties of the target transformations.
Lookup transformation advanced properties	Value of the advanced properties of the lookup transformations.
Sequence advanced properties	Current value of sequences.
In-out parameters	Retention policy and current value of in-out parameters.