This content has been marked as final. Show 3 replies
very happy to see you back. Ok, the data is sample.
and as for distinct..
the data column is different. The whole idea is to sum up the data column for all the records ..which carry same data..
You may now wonder..why i can't create a surrogate key or primary key ..this is a staging table or landing table.. finally i am loading this table in the hyperion planning. So, i am doing all the transformations in this table before the load in hyperion.
Feel free to suggest any alternate solutions ..