Answer / Pradip Kumar Dubey

Metadata refers to data about data, providing descriptive information about the characteristics, structure, and relationships of other data. In a data warehouse context, metadata includes details about data sources, data types, business rules, transformations, aggregations, and lineage. Metadata plays a crucial role in managing and organizing data within the data warehouse, facilitating efficient data integration, querying, and reporting.

What is data merging, data cleansing and sampling?

1 Answers  

---

Best Data Ware housing training institute in delhi

3 Answers  

---

what are the others of "bad files" and "discard files" when using sql*loader?

1 Answers  

---

Explain difference between snow flake and star schema. What are situations where snow flake schema is better than star schema to use and when the opposite is true?

1 Answers  

---

"A dimension table is wide but the fact table is deep," explain the statement in your own words.

1 Answers  

---

What are Data Marts?

2 Answers  

---

What is the metadata extension?

1 Answers  

---

4.Explain Snowflkeschema ?

6 Answers   EDS, HCL, IBM, iFlex, TCS,

---

Can you pass sql queries in filter transformation?

1 Answers  

---

What is MDX?

2 Answers   TCS,

---

Explain is olap databases are called decision support system true/false?

1 Answers  

---

What is confirmed dimension?

7 Answers   JPMorgan Chase,

---