pavan.daddanalla

 Profile Answers by pavan.daddanalla Questions by pavan.daddanalla

• Apr 14th, 2008

 

surrogate key  is a  separate key column which is  generated by surrogate key generator.
 routines are nothing but subset of functions

nikhilanshuman

 Profile Answers by nikhilanshuman 

• Nov 30th, 2010

 

A surrogate key is none business key. it can be a sequential number with no business meanings. these are useful for the underlying applications to maintain relationships between tables.

Routines are the piece of code written in Basic. there are various routines like before job subroutines, after job subroutines and transform functions. before job subroutine is be called before the execution of the job and after job subroutine is called after the execution of the job finishes. To call these routines, the setup is done is job properties of a job. (The routines need to be written and compiled separately). transform functions are similar to a function which calculates something and return values to the calling program.  For example say you have to calculate sum of two numbers. In this case, the two numbers will be passed as input parameters to the routine and the routine will return the sum to the calling process. Transform functions (Routines) can be called in user variable activity or in a basic transformer.

Nikhil Anshuman