why union transformation is active transformation?
Answers were Sorted based on User's Feedback
Answer / 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
Is This Answer Correct ? | 12 Yes | 2 No |
Answer / raji
Hai frnds,
According to my knoweledge,active t/f means which changes the number of rows that can pass through it.
coming to why union t/s is active.......because union t/f merges the data which is coming from two sources,it means that it summarizes the data which is passing through union t/f,with this the no.of rows coming from that will be less....
so it is an active t/f...
Thanks.....Raji
Is This Answer Correct ? | 3 Yes | 16 No |
Answer / hanumantharao
Active transformation means recieve n number of records and
return < or > that of n number of records.
Union transformation is Active transformation because it
return less than that of recieved records.
Is This Answer Correct ? | 1 Yes | 26 No |
If the source1 has 10 records and the it contains 3 records
and the same 3 records are in the second source,the second
source contains 10 records if we want to join them using union
t/r then the output is 17 records instead of 20 records.
thats why we say that UNION T/R is active t/r
Is This Answer Correct ? | 3 Yes | 32 No |
Answer / sony
actually union transformation is a passive
transformation,not an active transformation.
Is This Answer Correct ? | 1 Yes | 30 No |
In aggregator if u enable sorted input what will be the output and disable sorted wt is output
What is mapplet and a reusable transformation?
i have a session which creates a file every time when i runs the session, but it replaces the first file with second file,i want to append the second file follwed by first file when i runs the session,how to achieve this?
How to improve the performance of Aggregate transformation?
Hi Experts , Can you please help me regarding the below question How to remove first three rows and last three rows in informatica.. thanks and regards Natraj
How will restrict values in 0-9 and A-Z and a-z and special character.Only allowed these chars otherwise we will reject the records? what is the function we used to restrict...
How to load data in informatica ?
How do you load only null records into target? Explain through mapping flow.
what is distinct
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
what is the difference between informatica6.1 and infomatica7.1
What are the different clients of powercenter?