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  

---

what are business components in Informatica?

2 Answers  

---

what is a test load?

3 Answers  

---

how can i text accracy of ETL migration? i am very new to data warehousing. we are writing ETL scripts using SCRIPELLA tool. how can i test the correctness of data. and we are generating reports using pentaho . is there any easy way to test the pentaho. how can test these ETL scripts written in scriptella? thanks in advance

0 Answers  

---

Hi can anyone write query for the below input and output Table 1 col 1 100 Null 200 300 Table 2 col1 Null 400 700 800 o/p 200 700 800 2)sql col 1 contains 23x-5-45 26x-12-45 28x-10-50 o/p middlevalue should be greater than 10

0 Answers   Cap Gemini,

---

Explain etl mapping sheets?

0 Answers  

---

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

0 Answers  

---

How to delete data which is not in source table?

0 Answers   IBM, Saama Tech, Wipro,

---

how do use session mapping parameters ?(in which transformation)

0 Answers  

---

what do u do when DB time takes more?in sap bi

0 Answers  

---

Where can i get informatica certification Exam dumps and details? please forward it to emailid: krisboppana@yahoo.com

320 Answers   Accenture, College School Exams Tests, CTS, Flextronics, HCL, Infosys, NexGen, Patni, SO, Wipro,

---

I have two tables in two different database, so to join these tables which transformation will be better joiner transformation or lookup transformation?

2 Answers   Accenture, Saama Tech, TCS,

---