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 depict expression change?

1121

---

Explain the different kinds of facts.

982

---

difference between informatica 8.1.1 and 8.6

3677

---

in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records

2237

---

Explain direct and indirect flat file loading (source file type) - informatica

1318

---

what is INFORMATICA TESTING process

2294

---

Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance

1979

---

COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1

1954

---

explan ur project architecture?

2070

---

COM components can be used in Informatica

2392

---

what is mean by complex business rule ?

2162

---

Differentiate between reusable transformation and mapplet.

1096

---

What are the new features of informatica 9.x developer?

970

---

How are indexes created after completing the load process?

1647

---

What is a transaction control transformation?

1208

---