Load Dimension from attribute of another dimension

[tstagliano]

We are looking as part of our data load process to update a dimension which is being tracked as an attribute of another dimension. I will explain below

we have a client dimension where we have an attribute of industry for which that client belongs too.
we have an industry dimension which contains the values being stored in the attribute from the client dimension above.
from a data load perspective, we are only brining in the client code but we need to somehow set the TI process to update the industry dimension from the industry attribute of the client dimension.

We are running the process via Turbo Integrator version 10.2.2

[tomok]

Pretty basic stuff. If you are using the TI wizard just create a new variable, designate it as "Element" and assign it this formula: VNew = ATTRS('Client', ClientValueFromFile, 'Industry'). Then use this variable in the rest of the wizard where you do the dimension updating.

[tstagliano]

that was the route I was going. just to clarify, what do you mean by ClientValueFromFile within the formula?

[tomok]

that was the route I was going. just to clarify, what do you mean by ClientValueFromFile within the formula?

I don't know. You tell me. Whatever this means:

from a data load perspective, we are only brining in the client code

[tstagliano]

our data load is an ODBC connection to our SQL database where we are pulling data from a view. We have a number of fields in the view, one which is Client so I would guess that the Clientfield from the view would be the one I would use.

[Wim Gielis]

Yes correct.