what are the data modeling tools you have used?(polaris)

0 Answers  

---

Explain do we need an etl tool? When do we go for the tools in the market?

0 Answers  

---

what are the data sources extracted from logistics cockpit in sap bw project and what is the requirement for it ?

0 Answers   Accenture,

---

CAN ANY ONE SEND ME THE CODE FOR THE BELOW 1).REMOVE '_' FROM TELE PHONE "323-237-2323" AND SHOULD DISPLAY OUT PUT AS "323237232" 2). NEED TO ONLY "COMPANY.COM" FROM EMAIL FILED "TEST@COMPANY.COM"

11 Answers  

---

Explain the key challenges that you face while performing etl testing.

0 Answers  

---

---

1.Identify and discuss the problems which are occurred during data quality verification for the single-source and multi-source problems. 2.Testing has very important role in DWH. In ETL testing phase, how can we perform the integration testing and regression testing? 3.What are the perquisites of system testing and regression testing in ETL phase?

0 Answers  

---

Give a way in which u can implement a real time scenario where data in a table is changing and u need to look up data from it.How will u configure the look up transform for this purpose?

0 Answers  

---

what is architecture of your datastage project??? i came across this question many times in interviews in specific what can i answer plz help me.

2 Answers   IBM, Tech Mahindra,

---

diff b/w dwh & data mart diff b/w star schema & snow flake schema diff b/w fact table & dimension table what are the contents in requirement specification what are the docs needed for testing draw ur proj architecture

0 Answers   L&T,

---

Explain the difference between etl tool and olap tools?

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  

---