How many steps etl contains explain with example?

0 Answers  

---

Explain about enterprise scalability and roi of data integration suite?

0 Answers  

---

Explain about round-robi?

0 Answers  

---

how do u extract data from different data sources explain with an example?

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  

---

can be used COM component in Informatica ?

0 Answers  

---

hoe to access second value in mapping parameter if it is having more than one value ?????????????

0 Answers   SS Solutions,

---

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,

---

How etl testing is different from database testing?

0 Answers  

---

Difference between flat files and relational sources?

0 Answers  

---

how many steps are there in etl process?

0 Answers  

---

IN Informatica, I have 10 records in my source system. I need to load 2 records to target for each run. how to perform.please let me know. I know by using Mapping variable we can perform but how to load please any one explain.

3 Answers   TCS,

---