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
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
What is sorter transformation?
How will the document be delivered to me?
What is a dimensional model?
Under what condition selecting sorted input in aggregator may fail the session?
Explain target update override in informatica
Explain what transformation and how many are there in informatica?
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
how many types of dimensions are available in informatica?
How can you increase the performance in joiner transformation?
What is joiner transformation in informatica?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
explan ur project architecture?
Design a mapping to load a target table with the following values from the above source?