in my source i have 100 records, and 3 targets, i want to
load
1st record into 1st target,2nd record into 2nd target,3rd
record into 3rd target again 4th target into 1st target and
vice versa,how to achieve this?

Answers were Sorted based on User's Feedback



in my source i have 100 records, and 3 targets, i want to load 1st record into 1st target,2nd r..

Answer / venkatesh.malneni

here we want to conform one thing that's is there serial no
or not
if there is serial no then we can just take a router then
create three(3) groups
First group for First target
Second is for second target
Third is for third target
write the condition as fallows
mod(s.no,3)=1-------> first target
mod(s.no,3)=2--------> second target
mod(s.no,3)=0-------->third target
if there is no s.no in source then create s.no by using
sequence generator t/r


the flow will be as fallows
/--------->t1
src--->sq---->router/----------->t2
\------------>t3

or if u use sequence generator the flow will be

sequqncegenerator
| /--------->t1
src--->sq---->router/----------->t2
\------------>t3

Is This Answer Correct ?    16 Yes 0 No

in my source i have 100 records, and 3 targets, i want to load 1st record into 1st target,2nd r..

Answer / chandra

this can be done in two ways.....
1st one

after the SQ we can take EXP Tr
in EXP take one output port like O_SEQ
before EXP Tr take SGT Tr ...
In SGT properties enable cycling and
set START VAL 1 and END VAL 3
then connect the NEXVAL port into O_SEQ port of EXP Tr
after that take ROUTER Tr
in ROU Tr take 3 groups
1st group put condition as O_SEQ=1
2ns group O_SEQ=2 and
3 rd O_SEQ=3
and then drag the 1 st group data into TRG1
2nd group data into TRG2
and 3rd group data into TRG3

the fllow will be like
SRC--->SQ--->SGT--->EXP--->ROU-->TRG1
---> TRG2
--->TRG3

or
we can use MOD function in EXP Tr we can done this

Is This Answer Correct ?    8 Yes 0 No

in my source i have 100 records, and 3 targets, i want to load 1st record into 1st target,2nd r..

Answer / ankur saini er.ankur861@gmail.

i think the best way to achieve this is to add a cyclic
sequecn gen which will gen 1,2,3 again 1,2,3 again 1,2,3

addd a router then or 3 filters add dump the the data from
sep filters or router groups to the diff targets as
required..

Thanks...

Is This Answer Correct ?    2 Yes 0 No

Post New Answer

More Informatica Interview Questions

In session log thier should not be a single error how will u do

3 Answers   HCL,


What is the Process to creating lookup transformation in informatica

0 Answers   Informatica,


How do you load more than 1 max sal in each department through informatica or write sql query in oracle?

0 Answers  


How can you define user defied event?

0 Answers  


What is the Difference between PowerPlay transformer and power play reports?

1 Answers  






If the values in a row are 1,2,3,3,4,,4,5 then how a rank transformation can rank these values

6 Answers   TCS,


Differentiate between Load Manager and DTM?

0 Answers  


Load data to multiple targets according date. When First time session runs it should send to 1st target,second time session runs then send to 2nd target and goes on how to achieve it

1 Answers  


what is materialized view?

2 Answers  


have u done any performance tuning? how u ll do?

0 Answers   IMB, TCS,


A mapping contains (1) Source Table S_Time ( Start_Year, End_Year ) (2) Target Table Tim_Dim ( Date, Day, Month, Year, Quarter )

1 Answers  


Explain grouped cross tab?

1 Answers   Accenture,


Categories