hi Dinesh could you assist me with the code you specified for the file path like what type of code is it and where could I get to know about it -like websites where I could look upon great if could assist me
Hi Basilio, not sure I understood what you said properly, if you are talking about data transfer from SQL to ADLS, it is ETL, not ELT, or are you referring something else, I cannot figure it out :)
@@DineshPriyankara In my understanding if you use data factory you just simply Extract, Load and later do Transformation. Comparing to SSIS where you do Extract Transform and then load. Though it is not important. Good video though -)
@@basilio100 Your understanding is right, but if we isolate the data transfer from SQL DB to ADLS without considering any transformation after that, then the process can be considered as ETL, if there are transformations that need to be done on the data in the lake, then whole process can be considered as ELT. Since I do not consider much on later case in this video, did not think to talk about ELT :). Anyway, thanks for pointing out, this conversation will help to people who need a clarification on it.
Thank you so much bro, keep going, all the best.
Great ! looking after for more content!
hi Dinesh
could you assist me with the code you specified for the file path like what type of code is it and where could I get to know about it -like websites where I could look upon
great if could assist me
looks UI to create link services, datasets and pipelines are not available on portal,we can only create these through JSON. Dinesh am i correct?
Hi, Can you please show how to use powershell script as Custom Activity within Data Factory Pipeline? Thanks
Hey man, can you please show one demo for bulk copy for copying multiple tables? Thank you.
Excellent!
how do you convert a v1 pipeline to v2 pipline
also in v2 there is no option to code , there is something arm templates so how do you use that ?
hi can we extract streaming data through ADF
Didn't find any Add column option in my free tier for schema tab
Thanks Great Video can you do one on calling ML in ADF V2 That would be really helpful.
Thanks Hemanth, will be doing one on that soon.
useful one
If you have shown source data prior that would have been good to understand and your explaination on expression is not clear..
Time 1:56.
It is not ETL - it is ELT. -)
Hi Basilio, not sure I understood what you said properly, if you are talking about data transfer from SQL to ADLS, it is ETL, not ELT, or are you referring something else, I cannot figure it out :)
@@DineshPriyankara In my understanding if you use data factory you just simply Extract, Load and later do Transformation. Comparing to SSIS where you do Extract Transform and then load. Though it is not important.
Good video though -)
@@basilio100 Your understanding is right, but if we isolate the data transfer from SQL DB to ADLS without considering any transformation after that, then the process can be considered as ETL, if there are transformations that need to be done on the data in the lake, then whole process can be considered as ELT. Since I do not consider much on later case in this video, did not think to talk about ELT :).
Anyway, thanks for pointing out, this conversation will help to people who need a clarification on it.