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  

---

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,

---

What are cubes and olap cubes?

0 Answers  

---

what is the difference between date cache and lindex cache?

1 Answers  

---

What are snapshots?

0 Answers  

---

what happens if the info.server doesn't find the session parameter in the parameter file?

2 Answers  

---

Explain about round-robi?

0 Answers  

---

what is pmrep command?

0 Answers  

---

List few etl bugs?

0 Answers  

---

when should one create lookup transformation ?

2 Answers  

---

How can you use an Oracle sequences in Informatica ? You have an Informatica sequence generator transformation also. which one is better to use?

0 Answers  

---

what are the facilities provided by OLAP to analytical users?

1 Answers  

---