Answer Posted / mahaboob basha

Hi,
the only condition for a transformation to bcum active is
row number changes.
Now the thing is how a row number can change. Then there are
2 conditions:
1. either the no of rows coming in and going out is diff.
eg: in case of filter we have the data like
id name dept row_num
1 aa 4 1
2 bb 3 2
3 cc 4 3
and we have a filter condition like dept=4 then the o/p wld
b like

id name dept row_num
1 aa 4 1
3 cc 4 2

So row num changed and it is an active transformation



2. or the order of the row changes
eg: when Union transformation pulls in data, suppose we have
2 sources
sources1:
id name dept row_num
1 aa 4 1
2 bb 3 2
3 cc 4 3
source2:
id name dept row_num
4 aaa 4 4
5 bbb 3 5
6 ccc 4 6

it never restricts the data from any source so the data can
come in any manner

id name dept row_num old row_num
1 aa 4 1 1
4 aaa 4 2 4
5 bbb 3 3 5
2 bb 3 4 2
3 cc 4 5 3
6 ccc 4 6 6

so the row_num are changing . Thus we say that union is an
active transformation

Write the advantages of partitioning a session?

1285

---

What are mapplets?

1281

---

What is the maplet?

1131

---

What are the different ways to implement parallel processing in informatica?

1429

---

What is informatica metadata and where is it stored?

993

---

Differentiate between Load Manager and DTM?

2160

---

Can we get 1st record through Informatica(without sequence number).

1482

---

Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?

1094

---

Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance

2012

---

Slowly changing dimensions, types and where will you use them

1718

---

What are the main issues while working with flat files as source and as targets ?

1167

---

Clarify the utilization of aggregator cache record?

1006

---

What are the components of Informatica? And what is the purpose of each?

1058

---

How can we delete duplicate rows from flat files?

1231

---

What is the commit type if you have a transaction control transformation in the mapping?

1035

---