Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2014-09-13 07:51 AM

when we go for snowflake scheema model in project?

i want this answer help me

475 Views
0 Likes
4 Replies
Not applicable
‎2014-09-13 08:09 AM
Author

hi

Star schema vs Snowflake schema face off is the performance of these models.

The Snowflake model has higher number of joins between dimension table and then again the fact table and hence the performance is slower.

The Star model on the other hand has lesser joins between dimensions tables and the facts table.

hope this helps you.

Regards

322 Views
IAMDV
Luminary Alumni
Luminary Alumni
‎2014-09-13 08:16 AM

Santosh,

Are these interview questions? It looks like you're asking all the interview questions.

Cheers,

DV

www.QlikShare.com

322 Views
0 Likes
Not applicable
‎2014-09-13 08:32 AM
Author

You can get best out of QlikView with Star Schema in terms of performance and resource consumption.

Snowflake in a RDBMS gives advantage of savings some disk space since dimensions are normalized.

QlikView does not store duplicates anyways, so snowflake is not a recommended approach.

322 Views
MK_QSL
MVP
MVP
‎2014-09-13 09:10 AM

Santosh, would love to answer all your questions but have to say that if you check on Community you will get the same answer being asked and answered so many times....

It is just a bit search, little work around and you will get your answer without waiting for someone to answer...

Hope this will make clear to you..

Thanks and Regards,

Manish Kachhia

322 Views