Interested to Buy Any Domain ? << Click Here >> for more details...
Why the UNION TRANSFERMATION is an Active TRANSFERMATION
- 6 Answers
- 9733 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
Mention some types of transformation?
What is the function of look up transformation?
what is the hint? how to use it to reduce the query processing in program?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
write a query to retrieve the latest records from the table sorted by version(scd)
What are the different versions of informatica?
What is the sql query overwrite in source qualifier in informatica
can u give example for factless fact table
what are the Methods For Creating Reusable Transformations?
What is standalone command task?
Is it possible to create multiple domains on a single Informatica server?
Explain the scenario which compels informatica server to reject files?
What all join we can perform in LOOKUP transformation?
What are the different ways to implement parallel processing in informatica?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
