Update strategy transformation is an active transformation.How it changes the number of records that pass through it? Please explain....

2 Answers  

---

What is the difference between warehouse key and surrogate key?

1 Answers   Accenture,

---

Hi all, i am new to this site and new to Informatica too. I have few questions regarding that. 1) When we load flat files into target tables how do we identify duplicates? and where do load the duplicate records for further reference? 2) How do we do chage data capture? Is this Slowly changing Dimension technique? Thanks in Advance

3 Answers  

---

How to delete duplicate records if we have huge volume of records in a table ? (rowid is not the correct approach)

6 Answers   Puma,

---

Please let me know how we can implement the below scenario. In a single mapping,more than 500 sources (legacy,VSAM,relational) will be loading into only one target. Whenever I retreive the data(any record) from target, i need to find the details that the record belongs to which source. Thanks in advance..

5 Answers   iGate,

---

What all join we can perform in LOOKUP transformation?

0 Answers  

---

What is diff joiner and lookup

4 Answers   BirlaSoft,

---

I have a condition sal=100 and I created one router and in that two groups g1 and g2 in g1 Sal<=100 and g2 Sal>=100, first which condition will satisfy, and Why?

11 Answers  

---

How are the sources and targets definitions imported in informatica designer?

0 Answers   Informatica,

---

HOW CAN U FIND THE SESSION START TIME? chandumba2005@gmai.com

2 Answers   TCS,

---

Which transformation should we use to normalise the COBOL and relational sources?

0 Answers   Informatica,

---

What are the technical challenges faced in Informatica production support member? Give any one example and how to solve it?

0 Answers   CTS, Wipro,

---