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
- 8315 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 |
By using Transformation i need top most 5 employee salary from each deptwise? Deptno 10,20,30? which transformation we need to use?
What is an aggregator transformation?
Explain why we use partitioning the session in informatica?
How the Informatica Server reads perameter file?
My source is like bellow F.NAME M.NAME L.NAME A B C D E F G H I and out put should like S.NO F.NAME M.NAME L.NAME 1 A B C 2 D E F 3 G H I 4 UNNOWN UNNOWN UNNOWN How can we acheive? please explane me indetail
how to get the data from the client machine and how to get server location data to client loction can any one explain bit deep please..!
Hi gurus can any one tell me with a flow how to implement SCD Type 1 and SCD Type 2 in a single mapping.For some fields SCD type has to be implemented and for some fields scd type has to be implementd..Thank in advance....
What is the scenario which compels informatica server to reject files?
What are steps to follow Informatica migration from 7x to 8x? Pls Explain...
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
how u know when to use a static cache and dynamic cache in lookup transformation.
If one flat file contains n number of records., we have to load the records in target from 51 to 100.. how to use expressions in Informatica..?
Teradata 
