How do you avoid duplicate records with out using source
qualifier,expression,aggrigator,sorter and lookup
transformations ?
Answer Posted / manoj kumar
Good logic.
Thank you
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is DR strategy for Informatica project?
In development project what is the process to follow for an etl developer from day1
What is meant by lookup transformation? Explain the types of lookup transformation?
Is there any way to read the ms excel datas directly into informatica?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
Write the advantages of partitioning a session?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
What is workflow? What are the components of the workflow manager?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
What is repository manager?
How many transformations can be used in mapplets.
What are the basic requirements to join two sources in a source qualifier transformation using default join?
How to update source definition?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
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