Mention few test cases and explain them?

0 Answers  

---

What are three tier systems in etl?

0 Answers  

---

what are the facilities provided by OLAP to analytical users?

1 Answers  

---

SCD2 will work on only dimension tables as well as fact Table?

0 Answers   Infosys,

---

how to join two tables without using joiner transformation .advantages of joiner over lookup and vice versa.

2 Answers  

---

---

What are the various tools used in etl?

0 Answers  

---

how do u estimate the depth of the session scheduling queue? Where do u set the number of maximum concurrent sessions that Informatica can run at a given time?

0 Answers  

---

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 make u disappointmnets in u r career

0 Answers   Infosys,

---

I have a Flat file with more no. of Records also including duplicate values. But i need distinct values to one target and remaining records to another target in Informatica way

2 Answers  

---

Explain about enterprise scalability and roi of data integration suite?

0 Answers  

---

what is granularity in Data ware House?

0 Answers   IBM,

---