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

Mention few advantages of router transformation over filter transformation.

16


What are the modules in Power Center

671


I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?

36


Define enterprise data warehousing?

23


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?

15






What is meant by active and passive transformation?

24


can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com

3728


Enlist the tasks for which source qualifier transformation is used.

15


4 yrs etl devloper roles and responsibilities?any body give solutions

908


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

26


What could be the possible resons of locks by user?

42


What if the source is a flat-file? Then how can we remove the duplicates from flat file source?

16


How to join three sources using joiner? Explain though mapping flow.

13


Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?

11


According to his methodology what all you need before you build a datawarehouse

619