Interested to Buy Any Domain ? << Click Here >> for more details...
a soure table has 100 records how to load into 3 target
tables in a cumulative order
source target1 target2 target3
--------- -------------------------------------
1-100 1 2 3
4 5 6
- - -
98 99 100
- 2 Answers
- 8266 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / babu
Hi
Mapping:
========
Src==>SQ==>Exp==>Rtr(GRP1,GRP2,GRP3)==>T1,T2,T3
||
Seq
EXp:column1,Nexval(come from Seq Trans)
Rtr: have 3 groups
GRP1:MOD(Nextval,3)=1 ===>T1
GRP2:MOD(Nextval,3)=2 ===>T2
GRP3:MOD(Nextval,3)=0 ===>T3
| Is This Answer Correct ? | 23 Yes | 0 No |
Answer / babu
Hi,
mapping:
Src==>SQ==>Exp(Nextval,Src_column)==>Rtr(3 Groups)==>T1,T2,T2
||
Seq
the above dagram represents the data flow from source to targets
Seq:Sequence generator from generate the sequence
numbers(1,2,3)only Max Val=3,please enable cycle option.
Rtr:Router transformation have 3 groups,Grp1,Grp2,Grp3
Grp1=1 ==>T1
Grp2=2 ==>T2
Grp3=3 ==>T3
please let me know if any thing wrong.
| Is This Answer Correct ? | 16 Yes | 1 No |
how will u get 1 and 3rd and 5th records in table what is the query in oracle please help me
What are Target Options on the Servers?
How to get EVEN & ODD numbers separately?
Explain how many types of dimensions are available in informatica?
what is filelist concept in informatica
How i can Schdule the Informatica job in "Unix Corn Schduling tool" ?
Can you please mail me a copy of Informatica Certification Exam dumps to r_balakrishna@yahoo.com
How to update records in Target, without using Update Strategy?
What is lookup transformation?
What is the difference between Oracle performance and Informatica Percfomance? Which performance is better?
What is a data modeling?
where does the default group roew in a router is stored what is the default size of memory in router
Teradata 
