[Updated] Goldman Sachs Aptitude Test Questions and Answers
Practice List of TCS Digital Coding Questions !!!
Take 50+ FREE!! Online Data Interpretation Mock test to crack any Exams.
Technical Discussion :: Informatica

5 / 94

How do you remove Duplicate records in Informatica? And how many ways are there to do it?

Answer:

IN INFORMATICA TO REMOVE DUPLICATE RECORDS BY USING

FIRST WAY IS

USING SOURCE QUALIFIER TRANSFORMATION CLICK ON PROPERTIES AND SELECT DISTINCT PROPERTY THEN YOU WILL REMOVE DUPLICATE RECORDS.

BY USING SOURCE QUALIFIER YOU CAN OVERRIDE THE SQL QUERY YOU CAN REMOVE DUPLICATE RECORDS BUT IT IS WORKING ONLY FOR DATA BASE SOURCE NOT WORKING FOR FLAT FILES.

SECOND WAY:

IN SORTER TRANSFORMATION ALSO YOU CAN CLICK ON PROPERTIES TAB SELECT DISTINCT PROPERTY THIS SCENARIO ALSO WORKING TO REMOVE DUPLICATE RECORDS.

THIRD WAY:

Asked In ::

Post Your Answer Here:


Rate This: +0 -0     
Report    

Post Your Reply Here:

Alert me
q4i-reply-your-answer

Report Error

Please Login First Click Here

Most Popular Qs.