Slowly Changing Dimension Transformations

Question

Post reply

Slowly Changing Dimension Transformations

steve.jacobs

SSCommitted

Points: 1830
More actions
October 21, 2013 at 9:35 pm

#278344

Comments posted to this topic are about the item Slowly Changing Dimension Transformations

Viewing 15 posts - 1 through 15 (of 22 total)

You must be logged in to reply to this topic. Login to reply

Mr. Kapsicum SSCertifiable Points: 6128 More actions · Answer 1

Very easy for Data warehouse and ETL peoples ......................Not Even A second thought required 🙂

Ford Fairlane SSCertifiable Points: 7664 More actions · Answer 2

Good question, had to do a touch of reading but got it in the end.

Hope this helps...

Ford Fairlane
Rock and Roll Detective

Carlo Romagnano SSC-Insane Points: 22663 More actions · Answer 3

Carlo Romagnano

SSC-Insane

Points: 22663

October 22, 2013 at 12:55 am

#1660378

Good work! 🙂

sqlnaive SSCoach Points: 17437 More actions · Answer 4

Since I'm not much into ETL and going through learning curve, i had to check out for answer from web and in the meantime was glad to learn about SCD and it's types. Thanks. 🙂

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 5

Nice question, a bit easy for BI folks. 🙂

Type 3 SCD is however not supported by the SSIS slowly changing dimension transformation.

I also never encountered this type of SCD in any project.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Ed Wagner SSC Guru Points: 287026 More actions · Answer 6

As someone who doesn't work with it that much, I had to research the answer. I learned something from the question, so thank you.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

steve.jacobs SSCommitted Points: 1830 More actions · Answer 7

Koen:

While the SCD transformation does not natively adhere to level 3, I have used other transformations to accommodate SCD level 3.

Thanks

steve.jacobs SSCommitted Points: 1830 More actions · Answer 8

All:

I wanted to make this more of a definition for learning purposes. I am natively a BI person and I LOVE BI and related "true" statistical analysis (especially since the present and future of business).

Thanks to all.

Thomas Abraham SSChampion Points: 10761 More actions · Answer 9

Not easy for me, as I had to learn something first. So, it was the very best of QotD = learn something AND get points. 😉

[font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
Connect to me on LinkedIn

WWDMark Hall of Fame Points: 3157 More actions · Answer 10

sqlnaive (10/22/2013)
Since I'm not much into ETL and going through learning curve, i had to check out for answer from web and in the meantime was glad to learn about SCD and it's types. Thanks. 🙂

+1

MCITP
MCTS - E-Business Card
Twitter: WWDMark

Try not! Do or do not, there is no try

email: info@weekendwebdesign.co.uk
Personal Website: http://markallen.co.uk/
Business Website: https://www.weekendwebdesign.co.uk

Ken SSCoach Points: 17191 More actions · Answer 11

Very easy and relevant question for me as I do a lot of ETL and DW work.

Hany Helmy SSChampion Points: 13921 More actions · Answer 12

As I am not a big fan nor a current user of the Data Warehouse or ETL; so I had to do some researches about it to get the correct answer. But @ the end, learnt something new.

Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant

TomThomson SSC Guru Points: 104773 More actions · Answer 13

TomThomson

SSC Guru

Points: 104773

October 22, 2013 at 10:44 am

#1660605

Remarkably easy for a 2 point question.

Tom

Ken SSCoach Points: 17191 More actions · Answer 14

L' Eomot Inversé (10/22/2013)
Remarkably easy for a 2 point question.

Agreed, maybe it was marked for 2 points because we don't get a lot of DW-specific questions? Had it been an MDX question, I would expect 2 points.