How to eliminate duplicates from flat file..what is the
procedure

Answer Posted / ram

one more answer is ....
use an aggeregator transformation and select all ports
as 'group by'...then u will get distinct records...

Is This Answer Correct ?    6 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

can u any challenge your project?

1595


hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica

1636


What are the differences between a connected lookup and unconnected lookup?

639


what is song in infrmatica...?

1666


What are the components of Informatica? And what is the purpose of each?

611






How do you change a non-reusable transformation to reusable transformation?

589


Could you explain what is enterprise data warehouse?

547


In informatica workflow manager, how many repositories can be created?

773


Tell me about Propagate functions in informatica

518


What is a filter transformation?

559


How do you promote a non-reusable transformation to reusable transformation?

656


How to do unit testing in informatica? How to load data in informatica ?

641


if we have a delimiters at unwanted places in a flat file how can we over come those.

1561


Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance

1584


How can repository reports be accessed without sql or other transformations?

715