CODEWITHSUNDEEP
informatica
Vignesh
Vignesh

Reputation: 11

how to load deparment wise record for each run in informatica?

For example,i have 10,20,30,40..... deparment no, for first run need to load only 10 deparment no records, for second run need to load 20 deparment no records only soon for each each run each deparment no record

Please help,Thanks

Upvotes: 0

Views: 227

Answers (1)

SATHAR
SATHAR

Reputation: 11

If you are using ROUTER transformation for loading department wise then add one more condition like 

for dept no=10  ==> Dept no=10 and COUNT(LKP(in target table having dept no=10))=0

likewise u can use in the remaining dept nos....

Upvotes: 1

Related Questions