Answer / jz

Select Distinct Box at Source propeties level or jus
override sql in Session.

Answer / priya yadav

Hi,

I am not aware at session level but I can tell you the same
at mapping level.

Either Select Distinct in SQ itself or in expression, u can
use a variable v1 to store the business keys of the
records. This will store the business keys(based on which
you have to determine a record as duplicate) of the record

v1= A||B||C

Assign this to another variable v2. This will assign these
business keys to v2.

v2=v1( Now v2 will have value A||B||C)

Set Duplicate Flag as Y if V1= V2 else N.

Now the business keys are stored in v2. Next time the
record will come it will calculate v1 on basis of business
keys, if that record is duplicate v1=v2, and record will be
marked for duplicate. If the record has different business
keys then v1 <> v2, and the record will not be marked as
dupliacte.

Hope it helps.
Thankyou!!
Priya Yadav

How many types of sessions are there in informatica.please explain them?

0 Answers   Informatica,

---

can you avoid static cache in the lookup transformation? I mean can you

1 Answers  

---

In real time scenario where can we use mapping parameters and variables?

4 Answers   CSC, CSE,

---

how we can add header and footer to flat files?

2 Answers   Tech Mahindra, Zensar,

---

waht is dataware house

2 Answers  

---

What is blocking transformation?

0 Answers   Informatica,

---

Explain the difference between mapping parameter and mapping variable?

0 Answers  

---

What is the commit type if you have a transaction control transformation in the mapping?

0 Answers   Informatica,

---

in realtime which situations u can use unconnected lookup transformation

2 Answers   Patni,

---

select count(1) from emp? what is the o/p?

5 Answers   TCS,

---

What is CDC? How to implement CDC?

4 Answers   People Tech, TCS,

---

Reusable transformation and shortcut differences

0 Answers  

---