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

if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.

2195

---

Explain about cumulative Sum or moving sum?

1037

---

Is there any target staging area in informatica not staging area

2576

---

What is the difference between stop and abort in informatica

1088

---

Can we get 1st record through Informatica(without sequence number).

1475

---

How are indexes created after completing the load process?

1634

---

if we have a delimiters at unwanted places in a flat file how can we over come those.

2045

---

What is xml source qualifier transformation in informatica?

1217

---

What do you mean by blocking transformation?

1033

---

What are the differences between joiner transformation and source qualifier transformation?

1162

---

What is a snowflake schema?

990

---

Explain what is informatica metadata and where is it stored?

1046

---

What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?

1662

---

Why sorter is an active transformation?

1185

---

Explain lookup transformation is active in informatica

1087

---