one source to target loading insert new rows and update existing rows?

3 Answers   Polaris,

---

Hi If i had source like unique & duplicate records like 1,1,2,3,3,4 then i want load unique records in one target like 2,4 and i want load duplicate records like 1,1,3,3 then can any body please send me what is th scnario. my mail i shek.inform@gmail.com

6 Answers   HCL, Schneider,

---

My flat file source is C_Id 1-nov-2011 8-nov-2011 100 2000 1500 101 2500 2000 I want my Target as C_Id Week_Num Amt 100 45 2000 100 46 1500 101 45 2500 101 46 2000

3 Answers   Wipro,

---

Could any one to tell How to use the Oracle Analytic functions in Informatica?

1 Answers  

---

without using rank transformation how can we rank items by using some other transformations

2 Answers  

---

while for 100 records in source table loaded sucessfully in trgt table . assume ,session will take 10min or 5 min to successfully succeeded. then 100 million records r there in source how much time will take by session to succeeded. there no fail ok.trgt table will load 100 million records with out any errors . don't tell perfect time . assume your self how much time to succeeded?

1 Answers   IBM,

---

What are the informatica performance improvement tips

0 Answers   Informatica,

---

Can any one describe what is audit table briefly?how does it look like and what are the columns in it?

3 Answers   Syntel,

---

When will u go for Dynamic Cache and Persistent Cache? Pls explain with an example?

2 Answers   TCS,

---

What are the data movement modes in informatica?

0 Answers   Informatica,

---

Explain the features of connected and unconnected lookup.

0 Answers  

---

Design a mapping to get year of join for each employee.

4 Answers   Accenture,

---