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

CAN ANY ONE SEND ME THE CODE FOR THE BELOW 1).REMOVE '_' FROM TELE PHONE "323-237-2323" AND SHOULD DISPLAY OUT PUT AS "323237232" 2). NEED TO ONLY "COMPANY.COM" FROM EMAIL FILED "TEST@COMPANY.COM"

11 Answers  


When do we go for the tools in the market?

0 Answers  


what are the facilities provided by data warehouse to analytical users?

0 Answers  


IN Informatica, I have 10 records in my source system. I need to load 2 records to target for each run. how to perform.please let me know. I know by using Mapping variable we can perform but how to load please any one explain.

3 Answers   TCS,


what are the session parameters? How do u set them?

0 Answers  


what is the difference between date cache and lindex cache?

1 Answers  


Explain different types of partitioning?

0 Answers  


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

1 Answers  


Eliminating of duplicate records without using dynamic lookups

1 Answers  


what is different between sequential batch and concurrent batch and which is recommended and why?

0 Answers  


In Which Transformation We Can Use Having Clause In Informatica?

0 Answers  


how do u implement configuration management in Informatica?

0 Answers  


Categories