Warehouse DataStage Question:
Download Questions PDF

Explain Dimensional modelling is again sub divided into 2 types?

Warehouse DataStage Interview Question
Warehouse DataStage Interview Question

Answer:

a) Star Schema - Simple & Much Faster. Denormalized form.
b) Snowflake Schema - Complex with more Granularity. More normalized form.

Download Warehouse DataStage Interview Questions And Answers PDF

Previous QuestionNext Question
What is a project? Specify its various components?Explain How to handle the rejected rows in datastage?