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

What are the static cache and dynamic cache in informatica?

1192

---

What is workflow manager?

1049

---

How can we improve session performance in aggregator transformation?

1117

---

How do you load alternate records into different tables through mapping flow?

1872

---

What are the features of complex mapping?

1161

---

Describe an informatica powercenter?

1127

---

What does update strategy mean, and what are the different option of it?

1092

---

Explain informatica architecture - version 8 / 9

1092

---

Please let me know how to make Data masking in informatica..

1726

---

What is informatica etl tool?

1000

---

Explain the shared cache and re-cache?

1119

---

What is a standalone command task?

1205

---

What is the command used to run a batch?

1064

---

How do you load unique records into one target table and duplicate records into a different target table?

1261

---

What is the sequence generator transformation in informatica?

1184

---