Answer / Balbeer Singh

In data warehousing, a batch refers to a group of processing tasks that are executed together in a specific order. These tasks typically include ETL processes, data quality checks, and report generation.nnThere are two main types of batches:
1. Full Load Batch: This type of batch loads the entire dataset from source to target, often used when the data warehouse is being initially populated or when the source data has undergone significant changes.
2. Incremental Load Batch: This type of batch only processes new or updated records since the last batch run, improving efficiency and reducing data latency.

How can you implement many relations in star schema model?

1 Answers  

---

List any five applications of data warehouse.

1 Answers  

---

How are models actually derived?

1 Answers  

---

What Oracle features can be used to optimize my Warehouse system?

1 Answers  

---

if source contain 10records how you identify header and footer

2 Answers   Polaris,

---

What are the design methods of data warehousing?

1 Answers  

---

Advantages of de normalized data?

2 Answers  

---

Compare aggregates and data marts

1 Answers   TCS,

---

How to performance tune reports?

1 Answers  

---

Explain why denormalization is promoted in universe designing?

1 Answers  

---

Difference between PowerPlay transformer and power play reports?

1 Answers   CTS,

---

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

1 Answers  

---