How you load distinct records into one target and duplicate
records into another target?
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
can u any challenge your project?
What is different between the data warehouse and data mart?
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
Why filter transformation is an active one?
What are session parameters ? How do you set them?
What is a predefined event?
what is song in infrmatica...?
what is size of u r database?
What is intricate mapping?
On which transformations you created partitions in your project?
can you please explain me pre session and post session options?
What is transformation?
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
how to load dimension table and fact table. plz tell me the steps.
Explain pushdown optimization $pushdownconfig parameter - informatica