Why the UNION TRANSFERMATION is an Active TRANSFERMATION
- 6 Answers
- 7982 Views
- Emphasis, I also Faced
- E-Mail Answers
Answer Posted / narendra.s
1)A transformation that effect the no of rows or change the no of rows while processing the data.
2)In this way the union transformation is change the 10+5 records into 15 records.
3)union transformation can't remove the duplicate records.
4)we can create multiple input groups, but only one output group.
In this way we can cal union is an Active and Connected transformation.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are the differences between a connected lookup and unconnected lookup?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
how to create user defined function (udf) in informatica
Informatica settings are available in which file?
generate date / time dimension in informatica
Explain the different dimensions.
what is the complex transformation you used in informatica
can we override a native sql query within informatica? Where do we do it? How do we do it?
r u done any partitions in ur project?
What is an expression transformation in informatica?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
waht type of interface is used for testing the data in informatica
if we have a delimiters at unwanted places in a flat file how can we over come those.
What are the advantages of informatica?
What is a joiner transformation and why it is an active one?
