Forum Discussion

tmwright's avatar
tmwright
New Contributor
2 years ago

vStageSourceAndTargetDataWithAttributes 'Ri' field definition

I am trying to load data into a new cube from the vStageSourceAndTargetDataWithAttributes table.  I am seeing most lines duplicated numerous times and the only field I am seeing with different values...
Data Integration
Data Sources
Import
Valeria_Velez's avatar
Valeria_Velez
New Contributor
2 years ago

Hi, if you don't need the Ri field, you can probably use the SELECT DISTINCT statement in the SQL Script. This would help you to remove the duplicates. 

I hope this works!