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

What are the advantages of informatica?

956

---

how to load dimension table and fact table. plz tell me the steps.

2034

---

I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?

1712

---

Define sessions in informatica etl?

962

---

What do think which one is the better joiner or look up?

1143

---

can we override a native sql query within informatica? Where do we do it?

1065

---

What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?

2060

---

in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records

2177

---

How many input parameters can exist in an unconnected lookup?

1489

---

What is main use of mapplet?

1066

---

How can we improve session performance in aggregator transformation?

1038

---

How do you load first and last records into target table?

1096

---

How many number of sessions can one group in batches?

1090

---

How can a transformation be made reusable?

1076

---

What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks

5558

---