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

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.

if soource is having 10 records how will u insert 20 records to target

6 Answers   HCL,

---

 Informatica Checkpoints

0 Answers   DELL,

---

What is the difference between procedure and stored procedur?

2 Answers   IBM,

---

what is the process we used in joiner transformation,there is no matching column in sources?

2 Answers  

---

when load type is selected as bulk or normal in session level ?let me know the internal process and give me an example?

3 Answers  

---

---

What is Session and Batches?

0 Answers   Informatica,

---

what is $$$$?

0 Answers   TCS,

---

In a mapping i have three dimensions. If i want to pass a same surrogate key value to all the three dimensions by using one sequence generator is possible?If the mapping is containing single flow? And in the same case if the mapping is contaning 3 flows for the three dimensions then by using one sequence generator can we populate surrogate key (same value) to all the three dimensions?

6 Answers   IBM,

---

What are the Advantages of de normalized data?

3 Answers  

---

what is diff between IN and EXIT commands

1 Answers   HCL, Schneider,

---

What are the components of Informatica? And what is the purpose of each?

0 Answers   Informatica,

---

How to read data from flat file source if the data is in paragraph format?

2 Answers   Wipro,

---