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

Hi All, Can any one please send me the difference between informatica 7i and 8i versions, Thanks in advance. vinod

1530


Bonjour, svp je veut voir comment envoyer un mail en java et comment changer le droit d'accé d'un fichier en java: de lecture en lecture/écriture et merci d'avance ;)

1761


What are the Short cut Keys of Tally ERP?

1769


what is the purpose of checked Menu options

1978


hi This is radhika.Can anyone help me to know the question papers of NATIONAL INFORMATICS CENTRE for the post of scientific officer/engineer? if anyone know plz tell me question paper pattern

1525






can we retrieve only integer/String type columns from a table,if yes how?

1491


Definition of Singleton Class? what is the Purpose of it? what is the advantage?

1588


code for connection from windows forms to sql server

1705


Define Form modules, Class modules and Standard modules

1474


Given a cube of size n*n*n (i.e made up of n^3 smaller cubes), find the number of smaller cubes on the surface. Extend this to k-dimension.

671


< No Frames > tag is used for

2104


Find out the list of authorization objects which contains activity as a field? Thanks in advance.

1755


EXPLAIN UNARY OPEARATORS

1799


Q2. A memory location has physical address D5687h. Compute: a. The offset address if the segment number is D445h. b. The segment number if the offset address is B577h.

1625


how to data grid use in data bind?

1490