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

If we have lookup table in workflow how do you trouble shhot to increase performance?

2 Answers  

---

In pmcmd command we need to type -p:password. Will it be visible to others who is having access to this file ?

4 Answers   Puma,

---

Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?

0 Answers  

---

What does cheating measurement mean?

0 Answers  

---

I HAVE 10 records in source. I want to store i record in target 1, second record in target 2, third record in target 3, 4 th record again in target 11, 5th again in target 2, 6th again in target3 etc.... how it is possible?

5 Answers   Syntel,

---

What is critical mapping?

2 Answers  

---

What are the informatica performance improvement tips

0 Answers   Informatica,

---

Can we use the mapping parameters or variables created in one mapping into another mapping?

1 Answers   Informatica,

---

Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.

0 Answers   IBM,

---

how we load the data from source to staging area

4 Answers   TCS,

---

Can you start a batches with in a batch?

1 Answers  

---

I have a scenario with router transformation. but i dont want to capture records from default group. how can we achieve this.

3 Answers   Amdocs,

---