Explain pushdown optimization $pushdownconfig parameter - informatica

0 Answers   Informatica,

---

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  

---

Hi, In Router transformation I created two groups . One is Passthrough=> True Second one is CorrectId’s => Invest>50000 Here I have one doubt. Can’t I treat default group as Passthrough group (fist group) . Is there any difference between default group and Passthrough group in this scenario? Let me know if you want more information about this scenario. Advance thanks.

3 Answers   IBM,

---

What is a code page?

0 Answers  

---

Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?

0 Answers  

---

What is degenerated dimention table?

7 Answers   Patni,

---

how to improve performence by using sorted input in aggrigator t/r.

2 Answers  

---

What is critical mapping?

2 Answers  

---

Major difference between SQL override and Lookup Sql override

1 Answers  

---

i have oracle table A and target B. i don't know how many records. i want get get last record in table A as first record in target table B. write a sql query?

7 Answers   IBM, TCS,

---

what is the difference between repository & Intergration service

1 Answers  

---

Does Facttable Normalized or Denormalized?

2 Answers   IBM,

---