how can send duplicate records to one tableand non
duplicate records to one table with simple clear mapping?
Answer Posted / radhakrishnansk
Considering the source as flat file.
src-->Src qual ---> sorted transfomation -->trgt
|
|---> trgt
In sorted transformation, we can choose distict in
properties. So the duplicate is avoided.
correct me if I am wrong
Is This Answer Correct ? | 1 Yes | 11 No |
Post New Answer View All Answers
State the limitations where we cannot use joiner in the mapping pipeline?
Have you worked with/created Parameter file
Is stop and abort are same in informatica?
what are the deliverables?in your project?
What is update strategy transform?
What is the advantage of informatica?
can anyone explain me about retail domain project in informatica?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What is a stored procedure transformation?
What is union transformation?
Define filter transformation?
According to his methodology what all you need before you build a datawarehouse
can any one give some examples for pre sql and post sql(Except dropping and creating index).
What is the function of look up transformation?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not