Why the UNION TRANSFERMATION is an Active TRANSFERMATION
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
Enlist few areas or real-time situations where informatica is required.
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
What is primary and backup node?
What are the main issues while working with flat files as source and as targets ?
Name the different lookup cache(s)?
What are the designer tools for creating transformations?
What are the reusable transformations?
Whats the difference between informatica powercenter server, repositoryserver and repository?
What are the databases that informatica can connect to windows?
difference between informatica 8.1.1 and 8.6
What is a sorter transformation?
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
How is union transformation utilized?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
Can we get 1st record through Informatica(without sequence number).