Interested to Buy Any Domain ? << Click Here >> for more details...
why union transformation is active transformation?
- 6 Answers
- 24460 Views
- IndiGo, TCS, I also Faced
- E-Mail Answers
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
Difference between Target-based loading and constraint-based loading?
When do you use sql override in a lookup transformation?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
What is union transformation?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
Clarify the utilization of aggregator cache record?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
What are the different lookup cache(s)?
Please let me know how to make encryption and decryption with example?
How do you promote a non-reusable transformation to reusable transformation?
What are the informatica performance improvement tips
Why update strategy and union transformations are active? Explain with examples.
where to store informatica rejected data?
Explain the features of connected and unconnected lookup.
What is data movement mode in Informatica and difference between them?
