Data Transformation Manager verifies that the user who started or scheduled the workflow has execute permissions for connection objects associated with the session. Verify Connection Object Permissions: After validating the session code pages, the DTM verifies permissions for connection objects used in the session.
If the PowerCenter Integration Service encounters an error when converting data, it writes an error message to the session log. When you disable data code page validation, the PowerCenter Integration Service verifies that the source query, target query, lookup database query, and stored procedure call text convert from the source, target, lookup, or stored procedure data code page to the UCS2 character set without loss of data in conversion. Validate Code Pages: The PowerCenter Integration Service processes data internally using the UCS2 character set. You can use information in the session log in conjunction with the PowerCenter Integration Service log and the workflow log to troubleshoot system or session problems. The session log contains a complete history of the session run, including initialisation, transformation, status, and error messages. The DTM creates and expands session level, service level, and mapping level variables and parameters.Ĭreate the Session Log: Data Transformation Manager creates logs for the session. The DTM process forms partition groups and distributes them to worker DTM processes running on nodes in the grid.Įxpand Variables and Parameters: If the workflow uses a parameter file, the PowerCenter Integration Service process sends the parameter file to the Data Transformation Manager when it starts the DTM.
A partition group is a group of reader, writer, and transformation threads that runs in a single DTM process. The DTM scales the number of session partitions based on factors such as source database partitions or the number of nodes in a grid.įorm Partition Groups: If you run a session on a grid, the DTM forms partition groups. Perform Pushdown Optimisation: If the session is configured for pushdown optimisation, the DTM runs an SQL statement to push transformation logic to the source or target database.Ĭreate Dynamic Partitions: Data Transformation Manager adds partitions to the session if you configure the session for dynamic partitioning.
0 kommentar(er)
