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.

What is workflow monitor?

0 Answers  

---

Under what conditions selecting sorted input in aggregator will still not boost session performance?

0 Answers  

---

What are reusable transformations in how many ways we can create them?

2 Answers  

---

what is the main advantage of unconnected lookup

2 Answers   Cap Gemini,

---

how can one come to know wether the records loak into the target if we use update strategy

1 Answers   Wipro,

---

---

What is informatica worklet?

0 Answers  

---

hi guys i have an question how do you find out weather the column is numeric or combination of char and numbers or it contains char,numeric and special characters.

2 Answers   IBM,

---

What is a command that used to run a batch?

2 Answers  

---

What is the expected value if the column in an aggregator transform is neither a group by nor an aggregate expression?

1 Answers  

---

What is parameter file?

2 Answers  

---

what is curr val use for in sequence generator?

2 Answers   Emphasis,

---

Can we use Lookup instead of Joiner to join 2 tables? If yes which is faster and why?

2 Answers   TCS,

---