applymap

[Anonymous]

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!

[Miguel_Angel_Baeyens]

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.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

[#3]

t

[jpapador]

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.

[ngulliver]

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

[techvarun]

it based on primary key. so whenever you  don't have a primary key you are not able to use applymap

Regards