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

Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?

1197

---

Design a mapping to load the cumulative sum of salaries of employees into target table?

1423

---

What is a rank transform?

1024

---

differences between service based and product based?

1970

---

What are the mapping parameters and mapping variables?

1087

---

Performance tuning in UNIX for informatica mappings?

2506

---

Can anyone tell me the new features in Informatica 9 Version?

2032

---

How many types of sessions are there in informatica.please explain them?

1111

---

How can we remove the duplicates from flat file source?

948

---

how many types of dimensions are available in informatica?

997

---

Explain the difference between a data warehouse and a data mart?

999

---

What are the issues you have faced in your project? How did you overcome those issues?

2289

---

What is a shortcut and copy in Informatica and how two are different with each other?

1130

---

As union transformation gives UNION ALL output, how you will get the UNION output?

1040

---

How to extract sap data using informatica? What is abap? What are idocs?

1087

---