This blog contains Informatica tutorials, Complete reference to Informatica, Informatica Tutorial for Beginners, Informatica Real Time Scenarios with Answers, Informatica Interview Questions with Answers, Informatica FAQ, TIPS for learning Informatica, Learn Informatica online, Informatica Guide for Beginners, DWH Concepts, Informatica scenarios, Informatica Scenario Based Interview Questions with Answers, Informatica scenarios with solutions, Informatica Latest scenarios with answers
There is a source table and 3 destination table T1,T2, T3. How to insert first 1 to 10 record in T1, records from 11 to 20 in T2 and 21 to 30 in T3.Then again from 31 to 40 into T1, 41 to 50 in T2 and 51 to 60 in T3 and so on i.e in cyclic order.
Drag the source and connect to an expression.Connect the next value port of sequence generator to expression.
Send the all ports to a router and make three groups as bellow
mod(NEXTVAL,30) >= 1 and mod(NEXTVAL,30) <= 10
mod(NEXTVAL,30) >= 11 and mod(NEXTVAL,30) <= 20
mod(NEXTVAL,30) >= 21and mod(NEXTVAL,30) <= 29 or mod(NEXTVAL,30) = 0
Finally connect Group1 to T1, Group2 to T2 and Group3 to T3.