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

Where can we find the throughput option in informatica?

1061

---

generate date / time dimension in informatica

1125

---

Implementation methodology

1710

---

3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs

2251

---

What is an aggregator transformation?

1096

---

What is workflow? What are the components of workflow manager?

1174

---

Suppose we do not group by on any ports of the aggregator what will be the output?

1041

---

What are active and passive transformations?

1080

---

I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.

1637

---

What do you mean by worklet?

1064

---

-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?

5790

---

Name the different lookup cache(s)?

1232

---

How can we use mapping variables in informatica? Where do we use them?

1198

---

What is exclusive and normal mode for repository services?

1142

---

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

1203

---