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 is informatica metadata?

992

---

Where can we find the throughput option in informatica?

1029

---

What is Cognos script editor?

4185

---

How to create a non-reusable instance of reusable transformations?

1077

---

how to load rows into fact table in data warehouse

1133

---

How an expression transformation differs from aggregator transformation?

1008

---

Why update strategy and union transformations are active? Explain with examples.

1199

---

Repository user profiles

1727

---

How can we update a record in the target table without using update strategy?

1105

---

In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.

2018

---

Enlist the tasks for which source qualifier transformation is used.

1004

---

if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.

2160

---

tell me 5 session failure in real time how can you solve that in your project?

2223

---

How to generate sequence numbers without using the sequence generator transformation?

1158

---

How to partition the Session?

1066

---