Answer Posted / priya yadav

Any Tranformation that changes the no of passed records
while processing is an active transformation. Union
transformation unions the record from different
sources/transformations(whatever it is in mapping), so the
no of records input to it are different from the no of
records that you recieve as output from it. Thats why it is
considered as an active transformation.
For Example,

You union these records from tweo Sources:

Source A: Source B:

A 1 2 D 7 8
B 3 4 A 1 2
C 5 6 E 4 3

Total Input Records: 6

Output Target:

A 1 2
B 3 4
C 5 6
D 7 8
E 4 3

Total: 5

Hope it helps!!!
Thank you!!
Priya Yadav

hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you

9901

---

What are the tasks that can be performed using sq?

1143

---

What are the differences between oltp and olap?

1018

---

Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?

1847

---

What is a rank transform?

1146

---

What are the differences between joiner transformation and source qualifier transformation?

1238

---

How do you handle two sessions in Informatica

1219

---

How to call shell scripts from informatica?

1043

---

What is confirmed fact in dataware housing?

7107

---

what is informatica metadata?

1090

---

Name the different lookup cache(s)?

1294

---

What is fact table? Explain the different kinds of facts.

1126

---

How to go to the older version for a mapping?

1159

---

How to use pmcmd utility command?

1077

---

What is an expression transformation in informatica?

1092

---