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

Hi Every One,What is Use of Factless Fact Table ? Why we use Factless Fact Schema in the Projects waiting for reply? thank you

6 Answers  

---

Limitation of REPLACESTR. Is there any character limitation to it.

1 Answers   CTS,

---

what is the size of ur database(like oracle)

2 Answers   HP,

---

What is the default source option for update stratgey transformation?

1 Answers  

---

where to store informatica rejected data? How to extract the informatica rejected data?

0 Answers  

---

What the difference is between a database, a data warehouse and a data mart?

0 Answers  

---

Two different admin users created for repository are ______ and_______

1 Answers  

---

Why we use partitioning the session in informatica?

2 Answers  

---

how to join the two flatfiles using the joiner t/r if there is no matching port?

5 Answers   Cegedim,

---

IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??

0 Answers  

---

Generally how many Fact Tables and Dimensions Table you have used in the Project? Which one is loaded first Fact Table or Dimensions Table into the warehouse? What is the size of the Fact Table and Dimension Table? what is the size of the table and warehouse

5 Answers   TCS,

---

What is galaxy shema

2 Answers   CGI,

---