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  


Eliminating of duplicate records without using dynamic lookups

4 Answers   IBM,


What are the types of data warehouse applications and what is the difference between data mining and data warehousing?

0 Answers  


what is the difference between cubes and package in cognos

0 Answers   Cognizant,


how do u set the size of block buffer?

1 Answers  


Explain do we need an etl tool?

0 Answers  


Two different admin users created for repository are________and_________.

1 Answers  


give detail on the sales project how many number of dimensions & fact tables are used in projec briefly. how the four fact tables taken in the project.

0 Answers   HCL,


Explain me ETL project architecture in Detail?

0 Answers   Infosys,


what is meant by drill through?(Mascot)

1 Answers  


What are snapshots?

0 Answers  


What do you understand by active and passive transformations?

0 Answers  


Categories