What is data modeling and data mining?

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  

---

what is the difference between OLTP database and data warehousing database?

4 Answers  

---

how to do aggregation (year wise quantity ) using only source qualifier, the source is sql server date as datetime data type and target as flat file with year (string datatype)

0 Answers   Thomson,

---

Hi Guys, my requirement is to load 1 yr data from oracle to teradata database through abinitio etl graph.i need to schedule this as a monthly job.but i want to load 12 month data for the first time and from second time it should load last (recent) month data and delete 13th month data. For example For the first time it should load 201208 to 201108 data, second time it should delete 201108 month data and load 201209 month data. I developed garph to load 12 month data ,but i don't know how to handle above requirement as am new to abinitio. i greatly appreciate you help.Thank You.

0 Answers  

---

how do u decide whether u need to do aggregations at database level or at Informatica level?

1 Answers   QualTech,

---

What are the three tiers in etl?

0 Answers  

---

how do u really know that paging to disk is happening while u are using a lookup transform?

0 Answers  

---

how do u set partition points in the mapping?

0 Answers   Quintiles,

---

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

0 Answers  

---

what happens if the info.server doesn't find the session parameter in the parameter file?

2 Answers  

---

What is meant by incremental load?

0 Answers  

---