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

Define the various join types of joiner transformation?

561


In development project what is the process to follow for an etl developer from day1

1278


What is a sorter transformation?

657


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?

598


SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N

1684






What are the types of presistent cache in look up tr.

1545


What are the different types of transformation available in informatica.

634


How will the document be delivered to me?

613


Is stop and abort are same in informatica?

570


What are the various types of transformation?

642


Explain the pipeline partition with real time example?

651


Differentiate between a database and data warehouse?

652


Enlist the differences between database and data warehouse.

545


What is a repository manager?

646


What are the mapping parameters and mapping variables?

622