Hi Keshav - when i try this example at matching out put when i try to use join for any changes in designation i am getting below error message. DF-JOIN-010 at Join 'Join2': Non-equality joins should have broadcasted one of the join sides can you help to find the root cause for it.
Hi Vamsi, You need to broadcast one of the joining tables.. preferably (small table) may be left table.. that means you will be loading data from one of the joining tables into memory.. on top of that joins will be applied.. This Cluster proposed to optimize your load.
Good tutorial... Can you be bit louder... It's my personal experience after gone through your few videos... Anyways Thanks for sharing your knowledge... Way to go...
Thanks for sharing. It's really easy to understand. Have you ever gone through Custom Activity in ADF..? If yes, can we connect or could you please upload that video..
Hi, If you observe at last but one step, in case of designation change.. I am inserting new record from source there I am loading all the column values from source as new record (so if loaction and mobile number changed also be loaded with new values) and in next step I am updating is_active,from and To dates. I hope I answered your question.
Thanks for your comment. You mean to share source file ? if so, its mocked up data with only few records.. I guess you can mock up too. If still required I will see if I can put it in GIT.. Thank you.
Nice video Keshav...keep posting..
Very Informative video, cleared my all doubts. Thanks :-)
Superb.. I am happy
Hii Kesav ! at last stage in alter row, unable to map spilt2@unmatch@sid
Please sort me where I missed
All the steps are followed as it is yours
thank you, so much!
Hi Keshav - when i try this example at matching out put when i try to use join for any changes in designation i am getting below error message.
DF-JOIN-010 at Join 'Join2': Non-equality joins should have broadcasted one of the join sides
can you help to find the root cause for it.
Hi Vamsi, You need to broadcast one of the joining tables.. preferably (small table) may be left table.. that means you will be loading data from one of the joining tables into memory.. on top of that joins will be applied.. This Cluster proposed to optimize your load.
Your videos nice
where is the historic data for helen when u changed her location and johney phone .it should be 2 record for both. with active 0 and 1. right?
Hi Sarab, I didn't treat location and contact numbers as type-2.. only designation is type-2 attribute. I hope you got me.
@@KeshavLearnTSelf OK, i got you.. Do you have any reference using for hash type2?
May i have your emailid?
@@Sarabjitsethi please check if it's the same that you looking for m.th-cam.com/video/naiNjSxFjEc/w-d-xo.html
@@Sarabjitsethi kesav.reddi@gmail.com
Good tutorial... Can you be bit louder... It's my personal experience after gone through your few videos... Anyways Thanks for sharing your knowledge... Way to go...
Ok thank you
Thanks for sharing. It's really easy to understand. Have you ever gone through Custom Activity in ADF..? If yes, can we connect or could you please upload that video..
Very helpful
Glad to hear that
What if Designation, ContactNo, and location changed at a time? I mean to say changed in the same row!
Hi, If you observe at last but one step, in case of designation change.. I am inserting new record from source there I am loading all the column values from source as new record (so if loaction and mobile number changed also be loaded with new values) and in next step I am updating is_active,from and To dates. I hope I answered your question.
nice explanations bro, can you please write the steps it will be useful to better understand, am little bit confusing......
Great tutorial.. Can you share the template for this mapping is possible
Thanks for your comment. You mean to share source file ? if so, its mocked up data with only few records.. I guess you can mock up too. If still required I will see if I can put it in GIT.. Thank you.
Can you please make a video on how to deploy this in prod..?
Sure.. I will do soon.
And also uma pinni
Babai hai
Hi