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
Answer Posted / 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 |
Post New Answer View All Answers
Enlist the advantages of informatica.
Define the various join types of joiner transformation?
How do you take back up of repository?
How can we handle two sessions in informatica?
Differentiate between a repository server and a powerhouse?
How to update a particular record in target with out running whole workflow?
EXL informatica Questions
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
in reporting we add some new objects,how we get the count of the newly added objects to the report
Why update strategy and union transformations are active?
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
How to improve the performance of a session using sorter transformation?
How to generate or load values in to the target table based on a column value using informatica etl tool.
Define filter transformation?
What all are steps in up gradation of Informatica server?