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

Can we write to_date(three arguments) ? Will it work ? Advance thanks

1 Answers   Puma,

---

Why can't we use few transformations in mapplet ? like xml and target defintions, seq etc ?

2 Answers   IBM,

---

Hi can any one tell me the difference between persistence and dynamic caches? On which conditions we are using these caches?

3 Answers  

---

when load type is selected as bulk or normal in session level ?let me know the internal process and give me an example?

3 Answers  

---

What are the unsupported repository objects for a mapplet?

1 Answers   Informatica,

---

if i have records like these (source table) rowid name 10001 gdgfj 10002 dkdfh 10003 fjfgdhgjk 10001 gfhgdgh 10002 hjkdghkfh the target table should be like these by using expression tranformation. (Target table) rowid name 10001 gdgfj 10002 dkdfh 10003 fjfgdhgjk xx001 gfhgdgh xx002 hjkdghkfh (that means duplicated records should contain XX in there rowid)

5 Answers   iFlex,

---

What is InformaticaPowerCenter?

0 Answers   Informatica,

---

Hi Experts, I have a source table like this. Name Number Raj 2 Ram 1 Sam 2 John 1 In the target I need the ouptput like the below Raj Raj Ram Sam Sam John We dont know the number value . It will be changing as n.. Please help me regarding this. Thanks, Nataraj V

2 Answers   NTT Data,

---

lookup transformation with screenshots

0 Answers   TCS,

---

What is depict expression change?

0 Answers  

---

difference between top down(w.h inmon)and bottom up(ralph kimball)approach?

2 Answers   PayPal,

---

How i can Schdule the Informatica job in "Unix Corn Schduling tool" ?

2 Answers  

---