How can we eliminate duplicate rows from flatfile,explain?

Answer Posted / seshagiri

veere reddy,

Dynamic lookup will not work for flat file only static
lookup will work for a flat file

Is This Answer Correct ?    2 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to handle decimal places while importing a flatfile into informatica?

727


What is a surrogate key?

563


What is union transformation in informatica?

701


how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?

1976


Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?

1625






What is an unconnected transformation?

667


Make a note of the quantity vaults made in informatica?

561


waht type of interface is used for testing the data in informatica

1837


Differentiate between router and filter transformation?

617


What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?

7682


my source is junk data how will u remove that junk data by using unix please any one replay me

3246


Slowly changing dimensions, types and where will you use them

1278


What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?

720


What is the different lookup cache(s)?

616


Which means the first record should come as last record and last record should come as first record and load into the target file?

613