How do you load alternate records into different tables through mapping flow in informatica

preview_player
Показать описание
The idea is to add a sequence number to the records and then divide the record number by 2. If it is divisible, then move it to one target and if not then move it to other target.
#sequence generator,#router transformation,#even or odd

First create a new mapping and drag the source into the mapping.
Create an expression transformation. Drag the ports of source qualifier into the expression transformation. Create the following additional ports and assign the corresponding expressions:
v_count (variable port) = v_count+1
o_count (output port) = v_count

Create a router transformation and drag the ports (products, v_count) from expression transformation into the router transformation. Create an output group in the router transformation and specify the following filter condition:
MOD(o_count,2) = 1

Now connect the output group of the router transformation to the target1 and default group to target2. Save the mapping.
Рекомендации по теме