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

I have Flat file like the data, sal have 10,000. I want to load the data in the same format as sal as 10,000. Can anybody know the answer means please mail me. Thanks in advance.. My mail id is chandranmca2007@gmail.com

2 Answers   DELL, iGate,

---

How can a transformation be made reusable?

0 Answers   Informatica,

---

Differentiate between reusable transformation and mapplet.

0 Answers  

---

If one flat file contains n number of records., we have to load the records in target from 51 to 100.. how to use expressions in Informatica..?

6 Answers  

---

write a query following table bookid language 1234 english 1234 french 1234 spanish 1235 english i want the output are bookid lang1 lang2 lang3 1234 english french spanish 1235 english null null

1 Answers   TCS,

---

how the informatica server sorts the strings values in rank transformations?

3 Answers   TCS,

---

when we dont use aggregator in mapping ?

2 Answers   CSC,

---

What are junk dimensions?

0 Answers  

---

without matching columns in two tables. how can you join

5 Answers   BirlaSoft,

---

two tables from two different databases r there . both having same structure but different data . how to compare these two tables ?

10 Answers   HP, Patni,

---

How can we improve session performance in aggregator transformation?

0 Answers   Informatica,

---

How do we come to know the Source data/file is ready/Updated in the source location, when the session is scheduled for @12:00AM and ready to run its job ? or Can we schedule the session, when the source is updated in source location without any time constraint?

2 Answers   iFlex, TCS,

---