MD5 algorithm

Reply
Frequent Contributor
Posts: 116

MD5 algorithm

Hi All,

Please try to explain MD5 algorithm in easy words with respect to the DI Studio (SCD Type 2 loader).

Regards

Uma Shanker Saini

Super User
Posts: 5,258

Re: MD5 algorithm

What is that you what to know and why?

It generates a hashed unique value from text.

SAS(R) 9.4 Functions and CALL Routines: Reference, Second Edition

Data never sleeps
Frequent Contributor
Posts: 116

Re: MD5 algorithm

Hi LinusH,

Thanks for your reply. This is just for my learning with SCD Type 2 Loader.

As we know - For efficiency, cross reference tables are used during updated of dimension tables by the following transformations :

SCD Type 2, Key Effective date, lookup...

While learning for cross reference table - I got the word MD5 Algorithm.

Regards

Uma Shanker Saini

Frequent Contributor
Posts: 116

Re: MD5 algorithm

"The Encrypted concatenation uses the MD5 Algorithm."

Super User
Posts: 5,258

Re: MD5 algorithm

Well, all I can tell you it seems that the SCD uses this as a standardized way to do comparisons between source data and the corresponning valid row in the dimension table.

I belive for dimensin with long records it could be better performance. either way, it simplifies the coding in the comparison step, the alternative would be somthing like

case a.name <> b.name

or a.age <> b.age or

etc.

Data never sleeps
Ask a Question
Discussion stats
  • 4 replies
  • 273 views
  • 0 likes
  • 2 in conversation