Answer Posted / 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

what is informatica metadata?

982

---

How do you load only null records into target? Explain through mapping flow.

1974

---

Different qualification between a related rotate toward the sky and isolates look upward?

946

---

What are mapplets? How is it different from a Reusable Transformation?

1041

---

HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION

1862

---

Explain target update override in informatica

1059

---

Please let me know how to make encryption and decryption with example?

1866

---

What are the databases that informatica can connect to windows?

1008

---

What is mapplet in informatica?

995

---

What is an expression transformation in informatica?

972

---

How to convert multiple rows to single row (multiple columns) in informatica

1331

---

What the difference is between a database, a data warehouse and a data mart?

1097

---

What are connected or unconnected transformations?

1058

---

what are the fact table & dimensional table in pharmaceutical and hospotal related products???

2086

---

What is confirmed fact in dataware housing?

6843

---