What is the main difference between a Joiner Transformation
and Union Transformation?
Answer Posted / yaseen
we can create multiple input groups,but only one
out put group
Union Transformation combines data record vertically from multiple sources, having same metadata.
The structure and Data types should be same while using Union transformation
Join Transformation combines data record horizontally based on
join condition.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
what is INFORMATICA TESTING process
write a query to retrieve the latest records from the table sorted by version(scd)
What could be the possible resons of locks by user?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
What are the data movement modes in informatica?
What is the status code in stored procedure transformation?
What is a pre-defined event and user-defined event?
What is status code in informatica?
What is option by which we can run all the sessions in a batch simultaneously?
Define enterprise data warehousing?
Explain the code page compatibility?
How do you remove duplicate records in informatica? And how many ways are there to do it?
Suppose we do not group by on any ports of the aggregator what will be the output?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
How to update source definition?