question

vaishnavitatrashi-4555 avatar image
0 Votes"
vaishnavitatrashi-4555 asked vaishnavitatrashi-4555 edited

load fact data from .csv files to table perform the following vallidations

  1. load only .csv files.

  2. create reject file by rejecting the records due to truncate or data type mismatch error.

  3. check if there are any leading and tailing spaces on. if the measure column coming from source is null then convert it to 0.

  4. capture the details of files loaded.

  5. convert the business key to surrogate key.

  6. check if a record already exists on the basis of dimension data keys. if records already exists and a changed record is coming the file , then overwrite the data on the basis of dimension data key. if a new comes then insert the data

  7. In case package failure or any task failure, capture the failure details in another control table specifying package name failed, task name failed and the error details




sql-server-integration-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

0 Answers