Pivot Transformation question
I have a question related to Pivot transformation. I have the transformation working but having difficult to adjust the idea on how to load a dimension. I am trying to extract the data from a table that is in Key value Pair format and all of the Keyvalue has a key that joins to the main table. The effort i am trying to make here is to load dimension. All the dimension attribute that needs to be loaded are the Name values in Keyvalue. to avoid the setbased approach i am using Checksum to improve efficiency of the data loading process. Because I need to load the distinct values , i can't consider the Key column that joins to load in main table. But when i pivot the unique value that identifies the row is the Keycolumn. Using those value will not generate the unique rows output. Thoughts on how to solve the problem ?
May 26th, 2012 2:34pm
Have you sorted the rows by KeyColumn before using the Pivot? If you don't, you'll get several rows with the same KeyColumn, but with different pivoted columns filled in. Talk to me now on
May 26th, 2012 8:29pm