Dimension Processing Destination Editor in SSIS

I have designed couple of dimensions and fact table (star schema) from analysis service 2008.
The issue I am having is I am trying to use Dimension Processing Destination Editor in SSIS 2008 to poulate the dimensions But Whn I pull the dimensions I can only see the key columns and not all columns.
Am I missing something here?
LVL 8
venk_rAsked:
Who is Participating?
 
grzegorzsConnect With a Mentor Commented:
In Dimension Processing Destination you will see only key columns for each attribute defined in the dimension ( <attribute_name>.Key. Additionally if the attribute has the Name property defined you will see also a <Attribute>.Name column. Only those columns are required to fill dimension data. You don't need anything else.

best regards
Grzegorz
0
 
venk_rAuthor Commented:
Thanks
0
All Courses

From novice to tech pro — start learning today.