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?
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?