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

How to load data into 3 target tables which are in different schema but with the same name and same relational connection at infromatica level ? How to differentiate while loading ? and how to load ?

2 Answers   IBM,

---

I have table name called Team and I have name and DOJ in that table in oracle, when I retrive the table in Informatica DOJ shows with date and time , I want want to know is it possible to get only date(MMDDYYYY) in the date data type,

3 Answers   CSC,

---

What is confirmed fact in dataware housing?

2 Answers   Hewitt, TCS,

---

Explain lookup transformation is active in informatica

0 Answers   Informatica,

---

What are the types of maping in Getting Started Wizard?

1 Answers  

---

If session fails after loading 10000 records in the target,how can we load 10001 th record when we run the session in the nexttime?

8 Answers   HeadStrong, TCS,

---

What do you mean by filter transformation?

0 Answers  

---

How you can differentiate between connected lookup and unconnected lookup?

0 Answers  

---

While using update strategy in the mapping which gives more performance, a flat file or Table? Why? What are the advantages and disadvantages?

4 Answers  

---

What are the types of data that passes between informatica server and stored procedure?

1 Answers   Informatica,

---

What are the different threads in DTM process?

2 Answers  

---

How to create the source and target database connections in server manager?

0 Answers   Informatica,

---