Answer / Vinesh Kumar

Loops in data warehousing refer to situations where a process or operation needs to be repeated for multiple sets of data. However, it's important to avoid using loops as much as possible in ETL processes due to their negative impact on performance.

what is hybrid schema

4 Answers   TCS,

---

What is type 2 version dimension?

1 Answers  

---

How to add a number to a macro variable?

1 Answers  

---

What is the difference between view materialized view and view?

1 Answers  

---

Explain how does tuple-oriented relational calculus differ from domain-oriented relational calculus?

1 Answers  

---

Why joiner transformation does not allow the aggregator transformation and expression transformation to join

2 Answers  

---

Tell me one example for junk dimension?

9 Answers   TCS,

---

What is the difference between data warehouse and operational systems?

1 Answers  

---

What is the 4 + 1 view model as it relates to system modeling?

1 Answers  

---

Explain grouped cross tab?

1 Answers  

---

What are vaious etl tools in the market?

1 Answers  

---

What is the capacity of power cube?

2 Answers  

---