how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?

1 Answers  

---

What is etl process?

0 Answers  

---

What is virtual Data Warehousing?

0 Answers  

---

1. if lookup tr is giving poor performamence. what u do. 2. i have emp,dept table. i want output ename,empno,dname,max(sal). 3. can any one tell me project flow in real time scenario. please send me mail any queries and answers my mail id is yaparala@gmail.com

2 Answers   HCL, iGate,

---

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,

---

---

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 is a staging area? What is the purpose of a staging area?

0 Answers  

---

what is the difference between cardinality and Nullability?

0 Answers  

---

can cubes contain measures ?

0 Answers  

---

Is there any body who works on Pervasive Data Integrator (previously Data Junction)? Is there any scope also?

2 Answers  

---

Explain about round-robi?

0 Answers  

---

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

0 Answers   SS Solutions,

---