how to load dimension table and fact table. plz tell me the steps.

0 Answers   Cognizant, IBM,

---

What is DTM process?

4 Answers  

---

What is Target Update Override? What is the Use ?

8 Answers   Patni,

---

What is a diff between joiner and lookup transformation

16 Answers   CTS, Satyam, TCS, UHG,

---

Create a mapping which contains 2 target tables. When the session runs for the first time it shud load Target table 1 and when it runs for second time it shud load Target table 2.

7 Answers   TCS,

---

What if we sort the data in descending order instead of increasing order in sorter t/f and send the data in aggregator t/f is there any performance downfall? Please answer below. thank you.

4 Answers   JPMorgan Chase,

---

in which situations do u go for sequence generator ?

2 Answers   TCS,

---

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

4 Answers   Accenture,

---

What is the function of union transformation?

0 Answers  

---

Where are the source flat files kept before running the session?

0 Answers   Informatica,

---

we have to use order by,where,having we to implement sql query

1 Answers   Satyam,

---

How do we call shell scripts from informatica?

0 Answers  

---