lookup transformation in ssis | Lookup Scenarios | | SSIS tutorial Part 24

Lookup Scenarios in SSIS
Duplicate Data in Lookup Transformation Reference Data Set & Possible Outcomes
Handle Row yielded no Match Error for Lookup Transformation
Find Us On RUclips- "Subscribe Channel to watch Database related videos" / @ssunitech6890
For Quiz-
• sql server : Interview...
Find Us On FaceBook-
/ ss-unitech-18770538867...

[@rajsamant1]

Thanks, I am beginner and the way you are teaching, I feel I can learn within a month time...great learning with you..

[@ssunitech6890]

Yes Sure.
You would learn.
Can you please share to others

[@scoolshiv]

great

[@ssunitech6890]

Thanks

[@sathishgoud]

EXCELLENT EXCELLENT BRO.........

[@ssunitech6890]

Thanks brother

[@Prajapati_ram1996]

Good one

[@ssunitech6890]

Thanks dear 🙏

[@vaibhavsingh4043]

Very accommodating video thank you sir👌👌👌

[@ssunitech6890]

Thanks dear 🙏

[@AniL9325]

Awesome. Very helpful

[@ssunitech6890]

Thanks Anil for your continuous watching and appreciation..

[@shreyalande16]

Excellent!!!!!

[@ssunitech6890]

Thanks Shreya

[@selvamkumar1982]

Excellent.
. Can u pls tell disadvantage of Full cache...?

[@ssunitech6890]

Thanks Selvam,
The main disadvantage of full cache is it loads complete data from database to cache.
Thanks-SS Unitech

[@selvamkumar1982]

@@ssunitech6890 ok.. Can we get updated record for full cache since it loads all records in memory initially...

[@ssunitech6890]

Nope we can't.

[@selvamkumar1982]

@@ssunitech6890 then we wont get accurate result... How to handle this if it is Oltp?

[@ssunitech6890]

On that scenario we should use no cache option.
Thanks

[@ericsos101]

Do you provide datawarehouse/ ETL training

[@ssunitech6890]

Yes Eric, can you please call me @919971652428

[@ssunitech9252]

Helpful video👍👍

[@ssunitech6890]

Thanks dear 🙏