Answer / kish

union t/r means multi input source merged into single output
group.and also union t/r work as union all in oracle. and it
support duplicate data but union t/r having property is
their "make it active" enable them that's why it does not
accept duplicate record.this is the process

Answer / priyank

As per the definition of the Active transformation, the no
of rows going in should be equal to the no of rows going
out.Besides that the row id of the input rows should be the
same the row id of the out going rows.

Henceforth, union transformation is true for the first
condition where the no of rows entering is same as the no
of rows going out as Union transformation treats rows for
UNION ALL condition. But in the second condition i.e. Row
id,there is no control on the rows which enter the Union
transformation from different sources so the Row id can
change.

How to fix the etl bugs..Tell me the process?

1 Answers   IBM,

---

What is decode in static cache?

0 Answers  

---

Can you start a session inside a batch individually?

2 Answers  

---

Explain what transformation and how many are there in informatica?

0 Answers  

---

How do we eliminate duplicate records in a flat file without using Sorter and Aggregator?

7 Answers   iNautix,

---

What is DTM process?

4 Answers  

---

Source (Flatfile) - Target (1-1 mapping). How to load first or last 20 record to target?

5 Answers   Flextronics,

---

how do u move the code from development to production?

3 Answers  

---

how many new transformations are introduced in 8.1 which are not available in 7.1? any new transformation in 8.6?

2 Answers   emc2,

---

where to select code page option?

2 Answers   TCS,

---

scd methodology?

2 Answers  

---

can we generate reports in informatica ? How?

3 Answers  

---