Answer / Anoop Agarwal

Applications (also known as operational systems) are used to manage day-to-day business operations, such as sales, inventory, or customer service. They collect real-time data about these operations and provide tools for managing and analyzing this data. A data warehouse management system, on the other hand, is used to store and analyze historical data from various operational systems. It provides tools for data integration, transformation, storage optimization, and querying.

Explain what is the data type of the surrogate key?

1 Answers  

---

wht is degenerated dimension ?it's uses?

10 Answers   CTS, Infosys,

---

three ways sql*loader could load data, what are those three types?

1 Answers  

---

Explain the main difference between inmon and kimball philosophies of data warehousing?

1 Answers  

---

How to import vsam files from source to target. Do we need a special plugin?

1 Answers  

---

Explain clearly how to explain any (sales) project in interview. Actually feom where report developer work starts?pls reply as soon as possible?

1 Answers  

---

where exactly in dataware house a confirmed dimension can be created

4 Answers   Deloitte,

---

What is hybrid slowly changing dimension?

1 Answers  

---

Suppose you are filtering the rows using a filter transformation only the rows meet the condition pass to the target. Tell me where the rows will go that does not meet the condition 333 after we create a scd table, can we use that particular dimension as a dimension table for star schema?

1 Answers  

---

Explain why dimenstion tables are denormalized in nature?

1 Answers  

---

What is bi?

1 Answers  

---

Which one among Star and snowflake schemas will occupy more space?

1 Answers   Barclays,

---