Discuss the advantages & Disadvantages of star & snowflake schema?

5 Answers  

---

Source table ------------- ID NAME --- ------ 101 PANKAJ NULL KUMAR NULL MATHUR 102 JYOTI NULL SAXENA 103 SACHIN NULL TENDULKAR TARGET TABLE ------------- ID NAME --- ------- 101 PANKAJ KUMAR MATHUR 102 JYOTI SAXENA 103 SACHIN TENDULKAR IN ORACLE & INFORMATICA LEVEL HOW TO ACHIVE

2 Answers   Wipro,

---

Explain the types of transformations?

0 Answers  

---

i have two flat files.. containing same type of data i want to load it to dwh..how many source qualifires i need

7 Answers   Deloitte,

---

Difference between Target-based loading and constraint-based loading?

0 Answers  

---

Explain the use of aggregator cache file?

0 Answers  

---

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

0 Answers   Informatica,

---

What are the join types in joiner transformation?

1 Answers   Informatica,

---

How will you combine 3 different sources with a single source?

3 Answers  

---

I want expect first and last record remaining all records will be loaded into target? which transformations we can use?

6 Answers   Cap Gemini, CTS,

---

What are the unsupported repository objects for a mapplet?

1 Answers   Informatica,

---

Which kind of index is preferred in DWH?

3 Answers  

---