Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Folks,
I have created the data model in three different ways, Can anyone tell me which one is better approach to follow.
1) Approach
2> Approach :
I wanted to know which one is better from all respect like performance, reload and etc.
Guidence would be much appreciated.
Thanks
Sarfaraz
I am seeing only two approaches, is there a third one you wanted to show?
With regards to the performance, I don't see too much difference between the two... it's just a matter of preference as to how you would want you data model to look like? A single fact table or two fact table model?
Hi,
Where is the 3rd Data model?
Third approach is the join between two fact tables .
Sarfaraz
I would go first one
if you have an one to one mapping you should always go for apply map.
https://community.qlik.com/blogs/qlikviewdesignblog/2012/09/18/one-favorite-function-applymap
https://community.qlik.com/blogs/qlikviewdesignblog/2012/09/12/to-join-or-not-to-join
regards
Pradosh
I prefer approach one
Between approach 1 and 2, you prefer 1? What is the basis for this preference? I understand the preference of 1 between ApplyMap and a join... but not sure I understand how you can choose between 1 and 2?
I didn't mention i prefer 1st sunny. I provided the link for the OP to go through when apply map and when join . I guess you commented on the wrong comment.
You did mention that if it is a one to one mapping then you would go with ApplyMap. That means that you are indirectly suggesting to pick one. I wonder why. My comment was not to portray that you are wrong, I just want to know if I am missing anything