Answer / Rajani

Data Warehousing is a methodology for extracting, transforming, loading, and storing large volumes of data from operational systems into a central repository. The data in a data warehouse is structured, cleaned, and optimized for querying and analysis to support business intelligence and decision-making processes.

What are components of report studio?

1 Answers  

---

What is the "junk dimension"? Give with examples?

8 Answers  

---

How to pivot data using informatica when you have variable amount of pivot rows?

1 Answers  

---

Explain what is the limit to the number of sources and targets you can have in a mapping?

1 Answers  

---

Explain techniques of error handling - ignore , rejecting bad records to a flat file , loading the records and reviewing them (default values)?

1 Answers  

---

What is Bulk Insert?

3 Answers  

---

Explain difference between snow flake and star schema.

1 Answers  

---

What is the working process for application.cfm?

1 Answers  

---

Why do we use DSS database for OLAP tools?

3 Answers  

---

What are different stages of ?Data mining??

1 Answers  

---

Where can one get more info about Data Warehousing?

3 Answers   TCS,

---

for data loading in oracle, what are conventional loading , what are conventional loading and direct-path loading?

1 Answers  

---