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,

---

Can we make worklet inside worklet?

1 Answers  

---

What are the prerequisite tasks to achieve the session partition?

0 Answers  

---

when i was running the seesion, after loading 100 records, session suddenly fails.Next time i want to load the remaing rows in target with out truncate target table.What should i use?

7 Answers   Cegedim, IBM, TCS,

---

What is the query to find nth highest salary? What is the use of cursors?

8 Answers   Keane India Ltd,

---

---

Define informatica repository?

2 Answers   Wipro,

---

How your source files are coming to your ETL server. Actually at which stage of your mapping it is happen.

1 Answers   Cognizant,

---

Which transformation is needed while using the Cobol sources as source definitions?

0 Answers   Informatica,

---

how can we use sorter transformation in joins?

5 Answers   IBM,

---

Explain pushdown optimization and types in informatica

0 Answers   Informatica,

---

What is exact use of 'Online' and 'Offline' server connect Options while defining Work flow in Work flow ?

1 Answers  

---

Useful UNIX commands regular/frequently used

1 Answers   Deloitte,

---