why we use informatica in our project?

2 Answers   TCS,

---

Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?

0 Answers   Informatica,

---

Is snow flake or star schema used? If star schema means why?

4 Answers   CTS, Sonata,

---

scd methodology?

2 Answers  

---

Q. source having mutile depatment of data, dept1, dept2 ....dept10 today. we have mutilple depts in source, we need to generate dept1, dept2 and multile files in target side. today we have 10 dept which have 10 files, tommorow we have only 4 dept and 4 files, dayafter tommorow we have only 6 all the number of files in the targete file directory it's always dynamic. how can acheive it.

0 Answers  

---

What is best approach to load 100 different source files (Different structure) to differet target tables ?

2 Answers   IBM, TCS,

---

i have a session which creates a file every time when i runs the session, but it replaces the first file with second file,i want to append the second file follwed by first file when i runs the session,how to achieve this?

1 Answers   Thomson Reuters,

---

What is the difference between warehouse key and surrogate key?

1 Answers   Accenture,

---

Target increases every day even though no new record was inserted

0 Answers   Accenture,

---

how will compare two mappings in two different repository?

2 Answers   Real Time, TCS,

---

can u explain me banking domain projects ? and in banking domain projects how many dimension tables and how many fact tables and how to load source and targets in mapping level plese expain give me one example?

1 Answers   Accenture, Cognizant, HCL, IBM, iGate, L&T, TCS, Virtusa,

---

How can u insert o ne row in the target if that row does not exists in the target and update if it exists

6 Answers   Accenture,

---