To get hour basis records from the source to the warehouse it is recommended to have a table having a date field in the warehouse database i.e. (example 2010.01.01 17:00:00) .
first extract that date and then add 29 minutes to it using add(minutes,date) function for every KPI (Key Performance Indicator) set this date value in your SET VARIABLE and then access it in every desire Transformation through out he ETL script
It is possible within this short time period a record may not exist in the source data and the insertion will through an error for not entering string or nvarchar value in case of Integer value in the destination so remember set the default value to zero 0 while setting the name to variable in the SET VARIABLE property pallet. finally having successfully entering all the values in the destination update last processing date in the same table you created in the destination with the addition of 30 minutes.
first extract that date and then add 29 minutes to it using add(minutes,date) function for every KPI (Key Performance Indicator) set this date value in your SET VARIABLE and then access it in every desire Transformation through out he ETL script
It is possible within this short time period a record may not exist in the source data and the insertion will through an error for not entering string or nvarchar value in case of Integer value in the destination so remember set the default value to zero 0 while setting the name to variable in the SET VARIABLE property pallet. finally having successfully entering all the values in the destination update last processing date in the same table you created in the destination with the addition of 30 minutes.
0 comments:
Post a Comment