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

Answer Posted / 9019

Sorter select distinct, aggregator group by columns

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What does role playing dimension mean?

596


I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?

1292


Enlist the tasks for which source qualifier transformation is used.

564


What is a difference between complete, stop and abort?

617


Slowly changing dimensions, types and where will you use them

1248






What are mapplets? How is it different from a Reusable Transformation?

607


How to extract sap data using informatica? What is abap? What are idocs?

529


How do you load only null records into target?

715


which one is better performance wise joiner or look up

602


What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks

4732


How can we delete duplicate rows from flat files?

712


What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?

585


What is the need of an ETL tool?

616


Write the prerequisite tasks to achieve the session partition?

618


What is DR strategy for Informatica project?

668