What is algorithm in SCD Type2(SAS DI Studio Transformaton)?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain polymorphism. Provide an example.

620


In OB52 , How to define two open posting period, Like only 5 and 8 posting should be open.. should not open 6 and 7..period..

995


Given an array of size n+1 which contains all the numbers from 1 to n.Find the number which is repeated in O(n) time.How do you proceed with the same with floating numbers from 0 to 1 instead of 1 to n?

610


What are two of your strengths that you will bring to our QA/testing team?

1649


what is programmable BIST in today ic design

1649






what are the 3 forms of a prolog term

2757


Can we write a method in JSP.If so how?

1473


how many types of operating system are avaliable?

1823


What is %Type,%Rowtype?

1842


how do we provide security for web services

1813


details description on this mantis? who is founder of this mantis?

1687


Given an array all of whose elements are positive numbers, find the maximum sum of a subsequence with the constraint that no 2 numbers in the sequence should be adjacent in the array. So 3 2 7 10 should return 13 (sum of 3 and 10) or 3 2 5 10 7 should return 15 (sum of 3, 5 and 7)

765


How can we develop a multi-tier application in Java?

1473


what is adodb??y it is used for connection of V.B and access??what is ado?dao?

1778


iam confused among testing ,.net and java. can anybody help me.

1578