DataStage Tips: Which method is optimum to update the dimension table - 1. Direct update to the database in the same job using SCD. 2. By using SCD and creating a file with the change and using the file in next job?

Which method is optimum to update the dimension table - 1. Direct update to the database in the same job using SCD. 2. By using SCD and creating a file with the change and using the file in next job?

1 comment:

UnknownMay 11, 2011 at 2:27 PM
If we have large data set to be updated then option 2 is better approach.
ReplyDelete
Replies

Subscribe to: Post Comments (Atom)