Answer / swetha

Mapping designer

Tansformation developer

Mapplet designer

what is the location of parameter file in informatica?

1 Answers   TCS,

---

Generally how many Fact Tables and Dimensions Table you have used in the Project? Which one is loaded first Fact Table or Dimensions Table into the warehouse? What is the size of the Fact Table and Dimension Table? what is the size of the table and warehouse

5 Answers   TCS,

---

Which is better performance wise database or file?How?

2 Answers   TCS,

---

How many ways a relational source definition can be updated and what are they?

0 Answers   Informatica,

---

Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?

0 Answers   IBM,

---

---

How do we implement materialized view?when to use materialized view?

1 Answers   TCS,

---

WHAT IS FACT TABLES?

2 Answers  

---

difference between repository database and repository service?

0 Answers  

---

what is distinct

4 Answers  

---

what is constraint based loading

2 Answers   IBM,

---

Differentiate between reusable transformation and mapplet.

0 Answers  

---

How to Explain My project flow,In TCS ased me this question. In which way i can start my project flow and they asked how many fact tables and dimensional tables u used. Can any one Explain Briefly for this question and project architecture also.. please..

3 Answers   CTS, HCL, Infosys, TCS,

---