two sources S1,S2 containing measures M1,M2,M3, 4 dimensions D1,D2,D3,D4, 1 Fact F1 containing measures M1,M2,M3 and surrogate keys K1,K2,K3,K4 (a) write a sql statement to populate Fact table F1 (b) Design a mapping in Informatica for loading of fact table F1.

0 Answers  

---

Explain the key challenges that you face while performing etl testing.

0 Answers  

---

Explain about power designer data modeling software?

0 Answers  

---

what is the meaning of upgradation of Repository?

0 Answers   IBM,

---

in sap bw project at what scenario generic extraction is used and why explain and also tell why you used calendar day option explain?

2 Answers   Accenture,

---

Explain the use lookup tables and Aggregate tables?

0 Answers  

---

Can we create Hierarchies in generic datasources?

0 Answers   CTS,

---

please tell me any easy ways of testing the Data warehouse project. In my project we are not using any tools for ETL. we are writing scripts in SCRIPTELLA. And we using Pentaho tool for Reporting How can i test all these. please tell me ASAP. thanks in adavance

0 Answers  

---

what is the difference between date cache and lindex cache?

1 Answers  

---

What do you understand by the term ‘transformation’?

0 Answers  

---

What is the difference between Data Warehousing and Data Mining?

0 Answers  

---

how would u estimate the size of Aggregator transform data and index cache?

0 Answers  

---