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

When do you use sql override in a lookup transformation?

580

What do you understand by a term domain?

666

Explian the Process of deployment groups in informatica

651

While importing the relational source definition from the database, what are the metadata of source that will be imported?

784

What do you mean by blocking transformation?

579




What is the status code in stored procedure transformation?

683

How to load a Dimension ? and how to load a fact table?

949

Design a mapping to load a target table with the following values from the above source?

870

What is the format of informatica objects in a repository?

594

What is a pre-defined event and user-defined event?

575

Explain lookup transformation is active in informatica

657

Explain sessions and how many types of sessions are there?

576

I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?

1459

How can we update a record in the target table without using update strategy?

650

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

553