Eliminating of duplicate records without using dynamic lookups



Eliminating of duplicate records without using dynamic lookups..

Answer / murthy

use distinct at sql override,use agrgregator etc

Is This Answer Correct ?    1 Yes 3 No

Post New Answer

More ETL Interview Questions

Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.

0 Answers  


what is dynamic insert?

0 Answers  


What is Data Vault???

0 Answers  


we hava a flat file having more than 1000 records and two targets. i have to write first half of the rows into first targets and next half of rows into second target. how can i do in informetica??

1 Answers  


What is a materialized view log?

0 Answers  






When do we use dynamic cache and static cache in connected and unconnected lookup transformations? Difference between stop and abort

0 Answers  


Give a way in which u can implement a real time scenario where data in a table is changing and u need to look up data from it.How will u configure the look up transform for this purpose?

0 Answers  


what are business components in Informatica?

2 Answers  


flat filevalidation in informatica

0 Answers   Hewitt,


what are the data modeling tools you have used?(polaris)

0 Answers  


indatastage 8.1 surrgoate key generates seqences numbers write but there is limite value i want to reset the seqence after gettting some highest value like i want o/p like this 1 2 3 4 5 .............10000 1 2 3.........10000

1 Answers   TCS,


Explain about round-robi?

0 Answers  


Categories