What is full load & incremental or refresh load?

0 Answers  

---

What is etl process. How many steps etl contains explain with example?

0 Answers  

---

how do u identify the changed records in operational data?

0 Answers   QualTech,

---

How to delete data which is not in source table?

0 Answers   IBM, Saama Tech, Wipro,

---

if u can't find what you are looking for in lookup table, how do you handle?

1 Answers  

---

we have 1 source table containing 100 records. now we have to transfer first set of 1-10 (i.e1-10) records to one target table and another set of 1-10(11-20) records to other target table and continue like that till 100th record

3 Answers  

---

what is the difference between normal & bulk loading? and which one is recommended ? why?

2 Answers  

---

what are the concerns of OLTP and DSS systems?

0 Answers   TCS,

---

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  

---

can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.

0 Answers  

---

working of line item dimension......pls,tell overall flow

1 Answers  

---

In Which Transformation We Can Use Having Clause In Informatica?

0 Answers  

---