Should I put my transformation logic into my SQL query?

preview_player
Показать описание


Follow me on Twitter:
Рекомендации по теме
Комментарии
Автор

There’s also a third option, ORMs like entity framework can take advantage of both scenarios, generating on the fly queries that can transform and sort in the DB engine.

MiningForPies
Автор

Thanks for the video Bert!!! I'm not 100% sure what the topic was about - was it related to DW ETL/ELT, or OLTP transactions? Either way, thought-provoking :)

zanonilabuschagne
Автор

In my scenario I have to deal with a lot of linkedservers sendind large datasets around.
I wonder if, in this case, get data direct to an "transformation app" could deliver fastests results without penalize the servers like it´s done today.

marcosoliveira
Автор

I was interested, but as soon as there was an advertisement built into the video after I skipped the pre-roll ad I closed the video and will never watch anything from the channel again. Too bad.

kryori