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


Please Help Members By Posting Answers For Below Questions

What all are steps in up gradation of Informatica server?

610


Can one use mapping parameter or variables created in one mapping into any other reusable transformation?

586


What are the main issues while working with flat files as source and as targets ?

640


How to Create a folder using pmrep command?

608


tell me the rules and responsblites in our project(my project is development)

1487






What is a snowflake schema?

560


Briefly describe lookup transformation?

591


To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?

663


Sequence generator, when you move from develoment to production how will you reset

1393


I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.

762


What is meant by incremental aggregation?

569


What the difference is between a database, a data warehouse and a data mart?

586


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

1659


What is the need of an ETL tool?

631


What is an Integration service in Informatica?

693