Informatica records scenario

Question

I have huge no of records from source. I have to load first 1000 records into first target, second 1000 records into second target, third 1000 records into third target, fourth 1000 records into first target, fifth 1000 records into second target, next thousand records into third target and so on...can any one give me solution for this...I was able to load 3000 records into 3 different targets but unable to load 3001-4000 records into first target and 4001-5000 records into second target and so on...

Pls use 1. exp to calculate flag = iif (MOD(count,1000)=0 then count/1000,-1) 2. Use transaction control to create multiple files based on flag. 3. you need to add a filename n target and control the filename using expression. — Koushik Roy

NickW NickW · Accepted Answer · 2020-10-30T17:00:51

try something like this...

Use a sequence generator to tag each row with a row number
Create a calculated field that gives a value of 1, 2 or 3 based on the sequence value i.e using the logic you outlined in your question
Use a router transformation to direct each row to the appropriate target based on the calculated field

Informatica records scenario

1 Answers