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

Answer Posted / muddam

Select all ports as group by then Create one o/p o_count in
aggregater(o_count>1). Before this you wolud have taken one
sorter trans for sorted data.
It will work out.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain pushdown optimization $pushdownconfig parameter - informatica

695


suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do

1727


Explain informatica architecture - version 8 / 9

660


Tell me about MD5 functions in informatica

518


What are the new features of informatica 9.x in developer level?

551






What is the function of look up transformation?

644


State the differences between sql override and lookup override?

613


Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar

2269


What is informatica metadata and where is it stored?

579


Where is metadata stored?

615


Please let me know how to make encryption and decryption with example?

1456


What are different types of transformations available in informatica?

580


How to do unit testing in informatica?

715


source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.

2292


What is event and what are the tasks related to it?

607