How to send duplicates to one target and unique rows to one
target?target is empty

Answer Posted / vaas

Hi All,

One tbl has duplicate values means it does not has PK.In
this case can we use dynamic lookup.

Pl let me know, on vaas31@yahoo.in

Is This Answer Correct ?    0 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is mapplet in informatica?

590


Design a mapping to load the cumulative sum of salaries of employees into target table?

889


What is sq transformation?

658


How can you differentiate between powercenter and power map?

621


What is an expression transformation?

586






What do think which one is the better joiner or look up?

722


How to create Target definition for flat files?

752


Explain sql transformation in script mode examples in informatica

601


What is a stored procedure transformation?

607


Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar

2274


can we override a native sql query within informatica? How do we do it?

644


Is there any way to read the ms excel datas directly into informatica?

548


Explain incremental aggregation in informatica

650


Briefly define a session task?

588


How to create a non-reusable instance of reusable transformations?

674