Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


I HAVE 10 records in source. I want to store i record in
target 1, second record in target 2, third record in target
3, 4 th record again in target 11, 5th again in target 2,
6th again in target3 etc.... how it is possible?

Answers were Sorted based on User's Feedback



I HAVE 10 records in source. I want to store i record in target 1, second record in target 2, thir..

Answer / manthiramoorthy. g

S-SQ-EXP-SEQ-RTR-Tgt1,Tgt2,Tgt3

In Router: (Group Condition)
MOD(nextval,3)=0 Connect To Tgt1
MOD(nextval,3)=1 Connect To Tgt2
MOD(nextval,3)=2 Connect To Tgt3

Is This Answer Correct ?    16 Yes 0 No

I HAVE 10 records in source. I want to store i record in target 1, second record in target 2, thir..

Answer / teja_dwh

By using sequence generator properties we can do this.
setting the properties like below
start value:1
end value:3
cycle:yes
reset:yes
increment by:1
we can achieve the result by this way.

cheers
teja

Is This Answer Correct ?    7 Yes 2 No

I HAVE 10 records in source. I want to store i record in target 1, second record in target 2, thir..

Answer / rucha

i will use a sequence generator to get the row number then
input this sequence numbers to an expression transformation
where i will give an if condition (row number mod 3) then
the result be stored in a variable port say x.this variable
port value is filtered using router transformation as rows
with x=1 in group1,x=2 in group 2 and x=3 in default. the
resultant groups are connected to the targets 1,2 and 3
respectively

Is This Answer Correct ?    6 Yes 4 No

I HAVE 10 records in source. I want to store i record in target 1, second record in target 2, thir..

Answer / gyana

source--->sq--->attached a sequence generator with settings

current value=1
start value=1
end value=3
incrimented by=1
cycle=yes

------->router(3groups)--->3 targets

Is This Answer Correct ?    3 Yes 1 No

I HAVE 10 records in source. I want to store i record in target 1, second record in target 2, thir..

Answer / koti

hi rucha could u tell me how the mod function can works and
how it will gives answer 1 or 2 or 3 only...

Is This Answer Correct ?    2 Yes 6 No

Post New Answer



More Informatica Interview Questions

I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.

0 Answers  


I have in my source Records like 100,101,102 etc. I have router transformation which has groups like one group is empno=100, second group is empno>99. Now i want to know my source record 100 loads into which group?

5 Answers   Span Systems,


which one is costliest transformation? costliest means occupying more memory. which one Aggregator,sorter,filter,etc..

7 Answers   TCS,


How can you join 3 tables? Why cant you use a single Joiner to join 3 tables.

1 Answers  


Define mapplet?

0 Answers  






What are the phases in SDLC?

3 Answers  


what is mean by flag 4 in update strategy t/r

6 Answers  


I still need further explanation about the difference between active and passive transformation with some examples.Thank You

5 Answers  


what is the exact meaning of domain?

3 Answers  


Can we create a node as a gateway node and the same node can be assigned to a grid?

0 Answers  


For stage table data processing, suppose in first run we processed 8 records out of 10 records then in 2nd run we should consider only not processed records (here total no of records =2) along with new records which got loaded in stage table thru real time mapping. Note : In this example, 8 records are those records for which we got transaction number after lookup on trn_no_cod table and 2 records for which lookup returns trn_no as NULL

1 Answers  


What the difference is between a database, a data warehouse and a data mart?

0 Answers  






Categories