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 |
is possible to delete specific data in a row by using of sql query?
Diff between Proc transpose and Arrays with example?
In Bioinformatics, a DNA sequence is made up of a combination of 4 characters, namely “A,C,G,T”. A subsequence of a given sequence of characters a0, a1, …an- 1, is any subset of the characters taken in order, of the form ai0 , ai1 ,…..aik-1 where 0 ≤ i0 <i1….< ik-1 ≤ n-1. For example in the sequence “A,C,G,T,G,T,C,A,A,A,A,T,C,G”, we can have subsequences “A,G,T”, “A,C,A,A” and many more. A subsequence is palindromic if it is the same whether read left to right or right to left. For instance, the sequence “A,C,G,T,G,T,C,A,A,A,A,T,C,G”, has many palindromic subsequences, including “A,C,G,C,A” and “A,A,A,A” (on the other hand, the subsequence “A,C,T” is not palindromic). Devise an algorithm (using dynamic programming) that takes a sequence of characters X[0 … n-1] from the alphabet set (A,C,G,T) and returns the (length of the) longest palindromic subsequence. Implement the algorithm in an appropriate language.
in teradata level primary in table level allows duplicates why?
Explain the types of operations? Draw the figure for shift and rotate operations?
what is diff bet ref variable & instance of class
THE CHANNEL IN DATA COMMUNICATION CAN BE?
I m new to the dbms. Recently i came across words clustered indexes & nonclustered indexes but i dont know what is this all about & whats the difference between them.. So please help me!!!!!!!!
SAS using companies in INDIA
29 Answers Bank Of America, Cap Gemini, Hyundai, IBM, KO, Sristek, TCS, Wipro, WNS,
How same session variable can be used in both Asp and Asp.net?
What is the difference between CLEAR & RESET and OPEN & CLOSE OPCOEDS(USING RPG/400).wheare we can use this?can any body tell me in real time senario with example please?
hi..this is kartheek..complted mca in 2009..but i dont have knowledge in programing..but to learn new language.. which one is suitable for me?is SAP or IBM mainframes is suitable for me..?if it suits how much will it costs..?pls answer...