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  

---

Mention few test cases and explain them?

0 Answers  

---

indatastage 8.1 surrgoate key generates seqences numbers write but there is limite value i want to reset the seqence after gettting some highest value like i want o/p like this 1 2 3 4 5 .............10000 1 2 3.........10000

1 Answers   TCS,

---

When do we analyze the tables?

0 Answers  

---

how do u handle performance issues in Informatica . where can u monitor the performance ?

0 Answers  

---

Eliminating of duplicate records without using dynamic lookups

1 Answers  

---

Explain do we need an etl tool?

0 Answers  

---

List few etl bugs?

0 Answers  

---

When you have 2 servers in two different time zone and if you need to extract data from 1 server and load it in another server, how do you go about it? Best method to be used.

3 Answers  

---

What are the etl testing operations includes?

0 Answers  

---

list the transformation used for the following:Heterogeneous sources,Homogeneous sources,Find the 5 highest paid employees with in a dept,create a summery table,generate surrogate keys

2 Answers  

---

explain the methodology of Data Warehousing?(Polaries)

0 Answers  

---