All Forums Database
quest 20 posts Joined 12/09
28 Jun 2016
Transaction control in BTEQ script

Hi all,
I am coding for SCD (Slowly changing Dimension) 2 in BTEQ script. What should be ideal code to avoid mess up of data considering SCD-2?
As of now, if there is an error we quit but is there any optimal solution?

M.Saeed Khurram 544 posts Joined 09/12
28 Jun 2016

Is there a limitation to write this complex logic in BTEQ? Why dont you write a stored procedure and call that SP in BTEQ script?

Khurram

You must sign in to leave a comment.