What is algorithm in SCD Type2(SAS DI Studio Transformaton)?
Answers were Sorted based on User's Feedback
Answer / john
For more SAS DI related info visit
http://www.itinterview-madeeasy.com/2012/05/50-sas-di-interview-questions.html
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / senthilnathan.k
SC-2 Small Changing Dimension, We used for maintaining the
history of records.
ETL(Extraction, Transformation and Loading) the Data marts
called as target table using proc append, which will
appending the records in the target table using md5
algorithms.
Which will create Surrogate key corresponding to each
record.
| Is This Answer Correct ? | 4 Yes | 9 No |
ok how would i do the following extract from a file i have ssns = 267907230 which are in column 7 into a separate data set then create a 2nd job step to extract from the data set created the following "fund code" which is in column 31 and is 113 into yet another data set
what is difference between object oriented programming structure and object oriented programming system?
Difference between delegates and Events?
how many languages .net is supporting now?
Explain what is OOPS and its concepts?
How Many versions are there in crystal reports
what is the purpose of checked Menu options
How to find the aerry size
How to display questions one by one in jsp and I wants to store the answers in my database?
1.how to deploy the Maven application in weblogic server? 2.In Real time projects all classes are singleton or some classes only singleton explain? 3.what are the major uses of the designpatterns? 4.explain restful &Soap based services explain?
9.Difference between even and odd signals?explain with the diagram?
Is CTS company do serious backgroung check?