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


Please Help Members By Posting Answers For Below Questions

What is the differentiate between data file and descriptor file?

858


What is the difference between validated and compiled in the datastage?

695


Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance

1742


How to find value from a column in a dataset?

1763


Which algorithm you used for your hashfile?

682






What is job control?

620


How to read the length of word in unix?

878


What are the different plug-ins stages used in your projects?

619


What are data elements?

651


State the difference between an operational datastage and a data warehouse?

600


What are the steps required to kill the job in Datastage?

679


what is use of SDR function?

4704


Nls stands for what in datastage?

724


What are the main features of datastage?

655


What are the some differences between 7.x and 8.x version of datastage?

734