how will you remove the duplicate records from flat file
without using sorter?

Answer Posted / sathish

use aggregater T/R after source qualifier select all ports in group by clause it will removes the duplicates

Is This Answer Correct ?    5 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how tokens will generate?

1719


Separate from an archive server and a powerhouse?

480


Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com

1575


Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure

6445


what is INFORMATICA TESTING process

1826






What is the meaning of decode in informatica?

636


Dimension Object created in Oracle can be imported in Designer Cubes contain measures

1921


What are the different types of transformation available in informatica.

617


Can anyone tell me the new features in Informatica 9 Version?

1518


Reusable transformation and shortcut differences

1362


What is a shortcut and copy in Informatica and how two are different with each other?

664


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

584


Which files are created during the session rums by informatics server?

695


What is the session task and command task?

581


Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?

543