why union transformation is active transformation?
Answer Posted / venkateshmalneni
If the source1 has 10 records and the it contains 3 records
and the same 3 records are in the second source,the second
source contains 10 records if we want to join them using union
t/r then the output is 17 records instead of 20 records.
thats why we say that UNION T/R is active t/r
Is This Answer Correct ? | 3 Yes | 32 No |
Post New Answer View All Answers
What is the meaning of up gradation of repository?
What are mapplets?
What is an unconnected transformation?
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
What is an expression transformation?
How you prepared reports for OLAP?
What if the source is a flat-file?
Define sessions in informatica etl?
What does reusable transformation mean?
What is workflow manager?
What is substr in informatica?
What is target designer and target load order?
Can u generate reports in Informatica?
What differs when we choose the sorted input for aggregator transformation?
What is sequence generator transformation in informatica?