Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi!
I want to know if there's in some cases where you shouldn't use applymap. I have a datamodel where there's a few dimensions that only consists of two field. So my plan is to integrate them with the fact table.
Or can i screw things up doing that in some cases?
Thanks!
Hello,
I don't see any problem using ApplyMap other than a JOIN may perform better if your volume of data is high. Note that ApplyMap only allows two fields, and depending on your datamodel, this may not be enough or it may require to nest applymaps, and it may make the load slower...
Hope that helps.
BI Consultant
t
Apply maps only work for a 1 to 1 join as well. So if the key can have multiple values you'd need to use a join.
Hi, Annika.
Have a look at Steve Dark's blog. It may help.
http://www.quickintelligence.co.uk/applymap-is-it-so-wrong/
Regards,
Neil
it based on primary key. so whenever you don't have a primary key you are not able to use applymap
Regards