Processing Slowly Changing Dimensions with ADF Data Flows

Подписаться 225 тыс.

Просмотров 28 тыс.

50% 1

Do you want to learn how to slowly change dimensions with Azure Data Factory?
This session will begin with an overview of Azure Data Factory Data Flows and a review of dimension processing patterns, followed by demos.
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - -
Next step on your journey:
👉 On-Demand Learning Courses FREE Trial: www.pragmaticworkstraining.co...
🔗Pragmatic Works On-Demand Learning Packages: pragmaticworks.com/pricing/
🔗Pragmatic Works Boot Camps: pragmaticworks.com/boot-camps/
🔗Pragmatic Works Hackathons: pragmaticworks.com/private-tr...
🔗Pragmatic Works Virtual Mentoring: pragmaticworks.com/virtual-me...
🔗Pragmatic Works Enterprise Private Training: pragmaticworks.com/private-tr...
🔗Pragmatic Works Blog: blog.pragmaticworks.com/
Let's connect:
✔️Twitter: / pragmaticworks
✔️Facebook: / pragmaticworks
✔️Instagram: / pragmatic.works
✔️LinkedIn: / pragmaticworks
✔️RU-vid: / pragmaticworks
Pragmatic Works
7175 Hwy 17, Suite 2 Fleming Island, FL 32003
Phone: (904) 413-1911
Email: training@pragmaticworks.com

Опубликовано:

30 июл 2019

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 19

@abelfelleke7290 5 лет назад

Thank you it neat and briefly explained

@terryliu3635 4 года назад

Great intro! Thanks!

@vishal259 4 года назад

It would be good if you can upload scripts you have used in demo. It would be a good reference for audience.

@theownmages 4 года назад

how would i quarry to get a view of a dataset looked like at a spesific date, if i structured it like this type 2?

@moesmael 3 года назад

It was a very good explanation, but in Insert Sink, it will not insert newly updated rows with new Keys and new ActiveEnddate. Please make sure about the process, but I would like to thank you very much, it was a very good demo and helpful

@rohitnath5545 11 месяцев назад

Why do you think it wont work

@reckitt9173 11 месяцев назад

16:42 Correct me if I am wrong. This step will be prove bottleneck when data count is higher. Instead it would have added at 24:04 as lookup. We need a logic here for a data whose records found can be consider update and for other is insert.

@shivanityagi1073 Год назад

Can you please explain how to implement type 3 and type 2 scd in adf?

@YTEEsenior 4 года назад

On insert for uniqueidentifiers, how can you create a "new guid"?

@bobrubocki5305 4 года назад

Assuming you are loading to a SQL Server DB, you could create a default constraint and use the NEWID() function.

@srinin6252 3 года назад

its great explanation ,can you provide me the source file which you used for current SCD Type one? will try for that

@saswatibhattacharjee4992 3 года назад

ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE--cGPnND2880.html

@Sarabjitsethi 3 года назад

how are u taking care,if same hash exists ?

@kal1leo 4 года назад

how do I export and import a data factory including all the pipelines,data flows & data sets?

@rameshchowdary6390 4 года назад

You can go to resource group where you created your data factory and click on export. It generates json code then click on download. ARM Template will be downloaded to your local machine.