Answer / nagaraju bhatraju

take a lookup on t1 and look for dupliates in exp and
collect duplicate values to t2


or


you can hold preveious key value in variable port and can
compare it with new coming value , and you can flag these
rec as duplicate rec if both are matched , i mean previous
and current key, sorter should be used before exp as key
values should be come in sorted order only

(This technique is called forward referencing )

( Note : in other senarios if require you can use self
reference also basing on our requirements )

Answer / amedela chandra sekhar

with out p.key in the target table we can load.

Answer / chandra

in the source u overide the source qualifier and trough
filter u can overwriter it

Answer / swap

You can write UNION ALL query in source qualifier

eg:-select NAME,EMP_ID from EMPLOYEE
UNION ALL
SELECT NAME,EMP_ID FROM EMPLOYEE

How we can get unique records into one target table and duplicate records into another target table??

11 Answers   Deloitte, IBM, iGate,

---

If there are more than one sessions running parallel in a worklet, which will be the last session ?

2 Answers  

---

Hi, Can someone send me the DWH and Informatica FAQ's at priti.singh84@gmail.com Thanks in Advance, preeti

1 Answers   Accenture, Patni,

---

what is system requirement(SR) & business requirement(BR)?

2 Answers   Ness Technologies,

---

on a day i load 10 rows in my target and on nextday i get 10 more rows add to my target but out of 5 are update row how ican send them to target?how i can insert and update the records

4 Answers   Fidelity,

---

---

please let me know which type of question arise in interview on project manager round on insurance project with answer pls reply asap.

1 Answers   Accenture,

---

i have a source table ID NAME SAL 101 A 1000 102 B 2000 103 C 1500 target load should be ID NAME SAL 101 A 1000 101 B 2000 101 C 1500 102 A 1000 102 B 2000 102 C 1500 103 A 1000 103 B 2000 103 C 1500

3 Answers   TCS,

---

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 you differentiate between powercenter and power map?

0 Answers  

---

What is the Difference between sorter and aggregator?

2 Answers  

---

i have source file data empno,ename,sal 100,ram,1000 200,tyu,2000 300,gh,3000 out put as e empno,ename,sal 100,ram,null 200,tyu,1000 300,gh,2000 how to load it?

5 Answers   Cap Gemini,

---

create a mapping to retrieve the employees who are getting salary greater than average salary?

4 Answers   TCS,

---