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

What are snapshots? What are materialized views & where do we use them? What is a materialized view log?

0 Answers  


What is a lookup table in etl?

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  


please tell me any easy ways of testing the Data warehouse project. In my project we are not using any tools for ETL. we are writing scripts in SCRIPTELLA. And we using Pentaho tool for Reporting How can i test all these. please tell me ASAP. thanks in adavance

0 Answers  


can be used COM component in Informatica ?

0 Answers  


Can anyone explain me a scenario from banking and finance...more precisely a mapping

0 Answers   IBM,


what types of repositories we can create in informatica? in real time in which type of repository we will work on?

2 Answers  


In the SEQ generator which property has to be set to generate seq No. when the input data is more than the max limit.

3 Answers   Accenture,


what are the reporting tools and difference between them?

0 Answers  


Mention few test cases and explain them?

0 Answers  


how would u estimate the size of Aggregator transform data and index cache?

0 Answers  


What is etl process. How many steps etl contains explain with example?

0 Answers  


Categories