Eliminating of duplicate records without using dynamic lookups

Answer Posted / murthy

use distinct at sql override,use agrgregator etc

Is This Answer Correct ?    1 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how do u extract data from different data sources explain with an example?

1992


What is a materialized view log?

758


What is etl process? How many steps etl contains?

805


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?

1674


what is data modeling?

2083


What is cube grouping?

781


Can u access a repository created in previous version of Informatica?

1658


Explain different types of partitioning?

787


How can we use external procedural logic in informatica?

735


Mention few test cases and explain them?

725


What are the ETL Testing Operations?

831


In informatica, I have 10 records in my source system. I need to load 2 records to target for each run. How do I do this?

736


How many types of transformations supported by sorted input?

916


flat filevalidation in informatica

1932


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.

1760