How you load distinct records into one target and duplicate
records into another target?
- 3 Answers
- 15894 Views
- Mphasis, I also Faced
- E-Mail Answers
Answer Posted / shaik
Create a mapping with two targets.
> Create an Aggregator transformation and group it on the
distinct values and load it into Target1.
> Load the data directly in to Target2 since the source
have duplicates it will load all the duplicates.
| Is This Answer Correct ? | 5 Yes | 3 No |
Post New Answer View All Answers
What is informatica? Why do we need it?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
how to create user defined function (udf) in informatica
How does the aggregator transformation handle null values?
Is there any target staging area in informatica not staging area
What is a sequence generator transformation?
What is workflow? What are the components of workflow manager?
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
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
server hot-ws270 is connect to Repository B. What does it mean?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
Explain pushdown optimization and types in informatica
What are the guidelines to be followed while using union transformation?
What do you understand by term role-playing dimension?
What are different types of transformations available in informatica?
