Answer Posted / 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 are the Methods For Creating Reusable Transformations?

1183

---

How to update a particular record in target with out running whole workflow?

1584

---

What is target designer and target load order?

1111

---

What are the basic requirements to join two sources in a source qualifier transformation using default join?

1134

---

According to his methodology what all you need before you build a datawarehouse

1761

---

what is unit testing?tell me proceedure

2228

---

What is persistent lookup cache?

1037

---

What is aggregate cache in aggregator transformation?

1151

---

Which transformation should we use to normalise the COBOL and relational sources?

1216

---

What is the need for an etl tool?

1070

---

Define sessions in informatica etl?

1041

---

What is a filter transformation?

1050

---

What do you understand by term role-playing dimension?

1052

---

How to create or import flat file definition in to the warehouse designer?

1072

---

what is index?how it can work in informatica

2044

---