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

Briefly define a session task?

1195

---

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

1425

---

Can we create a Integration service without a Repository service and vice versa?

1257

---

Write the advantages of partitioning a session?

1332

---

Is it possible to revert a global repository to local one and why?

1135

---

Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.

2402

---

What are mapplets?

1328

---

Global and Local shortcuts. Advantages.

2089

---

I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.

1223

---

How to update source definition?

1141

---

If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me

2057

---

Can we change Dynamic to Static or Persistent cache? If so what happens?

2250

---

What is a repository manager?

1148

---

How we can use union transformation?

1104

---

Quickly characterize reusable change?

1184

---