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 is the benefit of partitioning a session?

1127

---

Explain scd type 3 through mapping.

930

---

how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?

6964

---

What is informatica metadata and where is it stored?

959

---

What is mapping debugger?

966

---

How are indexes created after completing the load process?

1577

---

How can you increase the performance in joiner transformation?

1162

---

What is the use of transformation?

967

---

can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com

4693

---

What is event and what are the tasks related to it?

1082

---

what is INFORMATICA TESTING process

2250

---

What is the meaning of decode in informatica?

1089

---

What is target designer and target load order?

1067

---

Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance

1947

---

Define pmcmd command?

1010

---