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
along with oracle which language will be beneficial to have knowledge with,java,.net,since i m doing oracle have appeared for 8th sem BEIT,plz suggest
How can recruiter justified that the candidate is expert in Algorithm and datastructure for Software product development ?
How do i find out the number of parameters passed into function?
SAS question: I have 50 fils a1,a2,...,a50. the primary key is upc. then if i want to merge all 50 files, the code is as follows, data test; merge a1 ... a50; by upc; run; we know that writing all 50 files name is time consuming, is there any standard format of this code?
MOV.CB 007H,ADCON1 MOVE.CT 001H,_OPTION_REG_7 MOV.CB 007H,CMCON
What is the use of sas software? Is sas and sap are different?
WHAT IS MAIN IMPORTANT THING IN SOFTWARE?
How to set fixed width in particular
Find out the list of roles which gives access to GUI activities? thanks in advance
how does database connection using ADO.NET?
What is the difference between COM and CORBA?
how to get second highest salary from a employee table and how get a 5th highest salary from a employee table by using proc sql?
Is the IT field raise again? What is the position of IT after 4 years?
Mainly Related to Oracle, DBMS , Oracle Stored Procedures, Functions, Oracle 9i Architecture, Redo logs..., Views,
In project we have Documentation phase also,in that what is micro and macro designing?