October 1, 2014 at 11:06 pm
Hello,
Could some one suggest me the transformation i need to use.
I am trying to merge two tables after an aggregation transformation. Since I want few columns to pass through. Could someone suggest the transformation I need to use. Merge and Merge Join I am not able to use since I have 12489 rows from one output and 241 rows from another output. I want to add these aggregated values as just separate columns not related to previous columns.
Source table cloumns are empname, country, age, gender, Question,Response (11200 rows) Aggregate transformation output columns are Questions and their responses (260 rows) In the destination I want all the columns from source table (empname, country, age, gender, Question,Response) and also Columns of Aggregated output (Questions and their responses) as extra columns.
Regards
Kavitha
October 2, 2014 at 1:43 am
Quick question, what is the data source and destination (file,table etc.)?
😎
October 2, 2014 at 1:52 am
Source is excel and destination is OLE DB
October 2, 2014 at 3:05 am
k.kavitha236 (10/2/2014)
Source is excel and destination is OLE DB
In this case, my first suggestion is to use a staging table at the destination for the aggregation. Is that an option?
😎
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply