using dynamic lookup in lookup t/r we can easily eliminate duplicates.

hw cn v elimate dublicate values from lookup without
overriding sql?

Question Posted / vijay

Answer Posted / vijay

using dynamic lookup in lookup t/r we can easily eliminate
duplicates.

Is This Answer Correct ?

2 Yes

1 No

Please Help Members By Posting Answers For Below Questions

Informatica settings are available in which file?

992

WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com

1922

Can we create a node as a gateway node and the same node can be assigned to a grid?

1082

Explain sessions?

1071

What is the Rank index port in Rank transformation?

1062

How do you load alternate records into different tables through mapping flow?

1874

Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?

1135

Enlist the differences between database and data warehouse.

1127

What is meant by target load plan?

974

What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?

978

Explain what are the different versions of informatica?

1099

Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?

1092

Design time, run time. If you don't create parameter what will happen

1837

Explain pushdown optimization and types in informatica

1080

how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?

7069