How to update or delete the rows in a target, which do not have key fields?

0 Answers   Informatica,

---

How is union transformation utilized?

0 Answers  

---

How do you do error handling in Informatica?

1 Answers  

---

In what scenario we use to improve session performance by pushdown optimization?can any one give example?

2 Answers  

---

i have source flat file like 1 a,1 b,1 c,2 a,2 b,2 c i want output as 1 a,b,c and 2 a,b,c ... how can achieve this

5 Answers   TCS,

---

What is dimensional table?

0 Answers  

---

difference between top down(w.h inmon)and bottom up(ralph kimball)approach?

2 Answers   PayPal,

---

What is an expression transformation in informatica?

0 Answers  

---

How to send duplicates to one target and unique rows to one target?target is empty

9 Answers   Amazon, IBM, Wipro,

---

What is a joiner transformation and why it is an active one?

0 Answers  

---

we have 20 records in source system, when we run for the 1st time, it should load only 10 records into the target, when you run for the second time it should load another 10 record which are not loaded. How do we do that? Can we write a SQL query in source qualifier to do it. This q' is asked in one f the interviews. Please let me know if anyone knows. Thanks

3 Answers   TCS,

---

How to load the data into target table, which not have Primary/Surrogate key (Duplicate records not acceptable)

5 Answers   TCS,

---