100 records in source and i have 3 targets, my requirement
is first record insert into 1st target,2 record into 2nd
target,3 record into 3rd target and again 4th record into
1st target like dat..how to implement dis?
Answers were Sorted based on User's Feedback
Answer / manthiramoorthy. g
SQ-->EXP-SEQ-RTR-TARGETS
Router
=======
Make 3 Groups
MOD(NEXTVAL,3) = 0
MOD(NEXTVAL,3) = 1
MOD(NEXTVAL,3) = 2
Is This Answer Correct ? | 13 Yes | 2 No |
Answer / mayur
SQ==>Sequence Generator(make it cycle of three)==> Filter
Tr==> Target
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / chandra
SQ--->EXP-->ROUTER---->TARs
In EXP take 2 output ports ,In one output port write
mod(id,3)=1and second Oport write mod(id,3)=2..,
Next drag the ports to ROUTER
In router take 2 groups ,IN first group write condition
mod(id,1)=1
and second group write condition mod(id,3)=2
finaly drag 3output groups into 3targets
Is This Answer Correct ? | 3 Yes | 3 No |
What is meta data and system catalog?
Is it passive or active when check and uncheck the box of DISTINCT in Sorter transformation? why?
6 Answers iFlex, Morgan Stanley,
What is partioning?how many types of partinings are there
What are the out put files that the informatica server creates during the session running?
What is workflow? What are the components of the workflow manager?
Can you generate sequence numbers without using the sequence generator transformation?
Define informatica repository?
How can we use mapping variables in informatica? Where do we use them?
What is 'PowerCenter Pushdown Optimization Option' in INFORMATICA ?
What does role playing dimension mean?
Hi all,Can any one provide me Informatica Designer Certification dumps.I need all three papers dumps.If any one has these dumps then plz send it on this id:- nagesh.jujjuru@yahoo.com Thanks in advance
differnece between joiner and a look up(please don't give just definitions)....i mean in which scenario it is better to use joiner and in which scenario better o use lookup ??