Answer / krithi

When you use 'Select Distinct' option , the Sorter
Transformation discards the duplicate records.

If you want to trace out the duplicate records, then send
the sorted data into Expression Transformation. Add a new
variable and compare the variable with the input data. If
the data matches then flag the record or else pass the
default row.And load all the flagged records into a
seperate table.

Answer / sudhar

You can use distinct to eliminate the duplicate records.

Otherwise if you wanted to send the duplicate records to
another table then sort the data, then using the expression
you can find the duplicate value, assign different constant
values for the duplicate and the normal one. Use the router
to send duplicate and orginal records to the different
target tables.

if the session fails after 100 records agian we have to starts the session or we go for recovery session

2 Answers   TCS,

---

What is rank index in rank transformation?

0 Answers  

---

Can you create a flatfile target

3 Answers   ABC,

---

Can a joiner be used in a mapplet.

1 Answers  

---

what is rank and dense rank in informatica with any examples and give sql query for this both ranks

4 Answers  

---

What do you mean by Parameter file? Why do we use it and what all things we can define in a parameter file?

1 Answers  

---

expain about the tune parameters?

0 Answers   TCS,

---

what is incremental data aggregation?

3 Answers   IBM,

---

in which situations we go for pesistent cache in lookup and which situations go for shared lookup cache?

2 Answers   Cap Gemini,

---

What is the Rankindex in Ranktransformation?

7 Answers  

---

Hi, If any hav Informatica n DWH FAQ's,Plz do fwd to vanibv6@gmail.com Thnx Vani

1 Answers  

---

Write a query to display Which deptno is containing highest Sal > avg (sum (Sal)) of all deptno; Avg (sum (Sal)) o f all deptno= 9675 Deptno, sum (Sal) 10 8750 20 10875 30 9400

7 Answers   iGate,

---