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
- 8322 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 |
Without source how to insert record to target?
Can we make worklet inside worklet?
Differentiate between a repository server and a powerhouse?
Global and Local shortcuts. Advantages.
wat s mapping parameter and mapping variable? how do you set that in a mapping?
write a sql query following source? subject mark maths 30 science 20 social 80 requird output maths science social 30 20 80
On a day, I load 10 rows in my target and on next day if I get 10 more rows to be added to my target out of which 5 are updated rows how can I send them to target? How can I insert and update the record?
How will restrict values in 0-9 and A-Z and a-z and special character.Only allowed these chars otherwise we will reject the records? what is the function we used to restrict...
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
One flatefile it contains some data but i want to dont want to load first and last record ..how it is? can u tell me complete logic?
i have a source with 100 records.i have 2 targets.in the first target i want to load first 50 records & in the second target i want to load next 50(or remaining) records.
What is ThroughPut in Informatica, How it works, Where I can find this option to check ?
Teradata 
