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==>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 |
Post New Answer View All Answers
Can informatica load heterogeneous targets from heterogeneous sources?
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
what is the size of u r source(like file or table)?
Explain the code page compatibility?
What is olap (on-line analytical processing?
What is data movement mode in Informatica and difference between them?
Mention a few design and development best practices for informatica?
According to his methodology what all you need before you build a datawarehouse
Explain the different dimensions.
What is a difference between complete, stop and abort?
What is the difference between router and filter?
What is a passive transformation?
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
What are roles and groups and benefits of using them?
How to open an older version of an object in the workspace?