Thank you so much Brother for the Kind Explanation..

This was asked to me in a recent interview, Thanks for clearing the concept.

@ankitbansal6

3 ай бұрын

Excellent!

yrrr you are a gem the kind of explanation you give😀

Learnt something new today thank you Ankit for making these kind of videos 🙏🏻

Totally new concept for me, thanks for sharing

Nice 😊

This is really helpful thank you

I learned something new today. Thank you so much for sharing such insightful content.😊

@ankitbansal6

3 ай бұрын

Glad it was helpful!🙏

Thank you so much Ankit for such a beautiful content ❤❤

@ankitbansal6

3 ай бұрын

Thank you so much 😀

Thanks!

@ankitbansal6

3 ай бұрын

Thank you 😊

Thanks for this but merge into can handle many other scenarios and it can get tricky

can't we do something like this trunacte table target_table_name; insert into target_table select * from source_table; if we want to have all 3 features together. Seems weird but still asking

@aryabhatt5833

2 ай бұрын

Right. But, I think when we are dealing with tables having millions of records and only a hundreds need insert, update or delete, then merge makes more sense.

Only if i learn sql can we got job reply jrur dena plj or plj video me thoda hindi me bhi smjhaya kro taki easily smjh aajae thanks i hope u reply soon

Very helpful. Whats the realtime application of this statement?

@ankitbansal6

3 ай бұрын

For implementing scd type 1, 2 and 3

@vijaypalmanit

3 ай бұрын

Very common in loading data while performing ETL

@VinitaRanaSherawat

4 күн бұрын

@@ankitbansal6how is history maintained?