Star Schema vs. Snow Flake Schema. What is the best model
for DW? Give example for both the models performance wise?
Answer Posted / chand
Star Schema is best choice...most of the project use star
schema. performance wise star schema is best.
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
Differentiate between data file and descriptor file?
What are the some differences between 7.x and 8.x version of datastage?
To see hidden files in LINIX?
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
How many Key we can define in remove duplicate stage?
What are stage variables and constants?
On which Dimension Table you implemented SCD Type in your Project
What is the purpose of pivot stage?
How do you register plug-ins?
What is a folder? Difference types of stages?
How to manage date conversion in Datastage?
Difference between data warehousing and olap?
Differentiate between operational datastage (ods) and data warehouse?
which r the connectors used in san?