how do u automate Extraction process?

1 Answers  

---

List few etl bugs?

0 Answers  

---

what is pmrep command?

1 Answers  

---

how can i text accracy of ETL migration? i am very new to data warehousing. we are writing ETL scripts using SCRIPELLA tool. how can i test the correctness of data. and we are generating reports using pentaho . is there any easy way to test the pentaho. how can test these ETL scripts written in scriptella? thanks in advance

0 Answers  

---

What are the different etl testing categories as per their function?

0 Answers  

---

Eliminating of duplicate records without using dynamic lookups

3 Answers  

---

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  

---

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  

---

you have created a lookup transformation for a certain condition which if true returns multiple rows. when you go to the target and see only one row has come and not all. why is it so and how it can be corrected.

3 Answers  

---

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

0 Answers  

---

What is a mapping, session, worklet, workflow, mapplet?

0 Answers  

---

what do u do when DB time takes more?in sap bi

0 Answers  

---