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
- 8405 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 |
What is the procedure for creating independent data marts from informatica 7.1?
What is the difference between bitmap and btree index?
what is INFORMATICA TESTING process
why do we go for update strategy tr in SCD rather using the session properties?
How will you update the first four rows and insert next four rows in a mapping?
Informatica and datawarehousing courses in Pune?
What is data transformation manager process?
can any one explain me about junk dimension
By using Transformation i need top most 5 employee salary from each deptwise? Deptno 10,20,30? which transformation we need to use?
Flat file heaving 1 lack records and I want to push 52000 records to the target?
how many tasks are there in informatica ?
15 Answers DELL, iGate, TCS,
Can we use parameters of parameter file in presession command
Teradata 
