Hi,
I get the error now on running the GL rapid mart.
1)Used already ‘delete from the table’ option.
2)Used 'auto correct option
3)Removed constraint from the table TIME_DIM.
Still the same.
13428 14736 DBS-070401 16/01/2014 20:38:05 |Data flow DF_TimeDim_SAP|Loader FirstOrDelta_FirstLoad_TIME_DIM
13428 14736 DBS-070401 16/01/2014 20:38:05 ODBC data source error message for operation : <[Microsoft][SQL Server Native Client 10.0][SQL
13428 14736 DBS-070401 16/01/2014 20:38:05 Server]Cannot insert duplicate key row in object ‘dbo.TIME_DIM’ with unique index ‘XIDX_TIME_DIM_3094’.
13428 14736 DBS-070401 16/01/2014 20:38:05 [Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.
its_ranjan (BOB member since 2011-02-16)