05-13-2014 04:09 AM
is there any standard option in SAS DI Studio to create or assign auto increment numbers column in the target table.
I am merging two tables using Append Transformation and need After or In Append Trans.
Please guide me if there is any possibility.
05-13-2014 04:46 AM
Well, depends on what you mean by "automatic", or "standard"...
There is no real good options/transformation to do this as simple as you describes, and in a efficient way. When this requirement emerge, I usually see three options:
05-13-2014 06:02 AM
I think there is no direct / good option in DI Studio to do this like Load Time Column in Table Loader Transformation.
Just managed it with User Written Code Transformation.
Thanks for reply.