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

2 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 HISTOGRAM? how to generate statistics?

1 Answers  

---

What are the steps involved in etl process?

0 Answers  

---

what is the meaning of upgradation of Repository?

0 Answers   IBM,

---

Compare etl & elt?

0 Answers  

---

what is a parameter when and where do u them when does the value will be created. Designing time, run time. If u don't create parameter what will happen?

1 Answers  

---

Hi, I've a mapping with flat file source The target update override property for the target table is using update stmt. There is no update strategy between source and target. Also The session has the target properties as Insert , Update as update options checked. Does this mean that recs will be inserted only and the update override will not be applied at all. Thanks

0 Answers  

---

What is virtual Data Warehousing?

0 Answers  

---

what are the production issues in datastage?

0 Answers  

---

where are the log files generally stored.Can you change the path of the file.what can the path be?

0 Answers  

---

how do u implement unconn.stored proc. in a mapping?

1 Answers  

---