1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

why union transformation is active transformation?

Question Posted / mahaboob basha

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

Is This Answer Correct ?    12 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Differentiate between source qualifier and filter transformation?

1003

How to extract the informatica rejected data?

757

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

5835

What are the new features of informatica 9.x at the developer level?

609

What are the new features of Power Center 5.0?

1236




What is joiner transformation in informatica?

629

Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?

1242

During the running session, output files are created by informatica server. Enlist few of them.

546

what is the hint? how to use it to reduce the query processing in program?

6326

Which is the t/r that builts only single cache memory?

714

what is the -ve test case in your project.

1856

What are mapplets?

826

Explain how to import oracle sequence into informatica?

594

Explain what are the different types of transformation available in informatica.

575

Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com

1594