Home i5/OS Integration CDC Power Center Mapping Description

CDC Power Center Mapping Description Featured

Written by 
Rate this item
(3 votes)

The most complicated and significant session in change data capture (CDC) workflow (See the workflow) is the one responsible for transforming transaction journal entries in to database rows. In our solution, the role is taken by s_CDC_Replication_from_i5OS replication session session. 

 Mapping for session transforming journal entries into database rows

 Please notice, Entry Specific Data is transformed (red line) into database row represented by ESD field/port in the target transformation named TargetDatabase. In any database a row must belong to a table. In our case, TargetDatabase transformation must know to which table processed row belongs. The data are encapsulated in EntrySpecificData field and passed to ESD field. Therefore, an addition of new table does not require changes to presented mapping.

The same is true, when a table structure is changed. The solution is possible due to new "Generic Target" connector for Informatica® Power Center.

 The presented solution, allows to build real time mapping in minutes, where the task does not depend on number of tables to be replicated. At the moment, the solution does not create new tables in target database but it is intended to do so.

I can help you remotely wherever you are. I am ready to make my solution better and solve your issues with change data capture from IBM i (as400, i5/OS, iSeries) . My email is This e-mail address is being protected from spambots. You need JavaScript enabled to view it .  

Read 111 times