Test Cases for Full Load and Incremental Data Load in ETL Testing

Test Cases for Full Load and Incremental Data Load in ETL Testing
#etltesting
#testcase
#etl
Blog - www.testerhoon.com

[@aloksingh.18]

It's very relatable to my project.Thanks for sharing this information.Keep posting such type of content.

[@testerhoon28]

thank you 🙏

[@vasugin2734]

Please talk in English it's very useful to who are all not know Hindi

[@sameerbharti5705]

Thanks for sharing ! helpful

[@mrrahaman6246]

Thank you so much for your Efforts to make this video

[@testerhoon28]

🙏🙏

[@travelwithmayur527]

Thank you for effort

[@travelwithmayur527]

You are shear very good knowledge keep it up mam....very useful for us

[@testerhoon28]

thank you 🙏

[@ishasinfo2432]

Thanks a lot Sissy❤️❤️❤️...I commented u about this just 2 days back..n u posted it...hope I can learn many more from ur classes🙏🙏🙏🙏

[@testerhoon28]

🙏🙏✌🙂

[@praveensk1622]

such a relatable information, good teaching skill mam

[@testerhoon28]

thank u 🙏

[@dastageerpinjar5065]

Thanks a lot very Best info

[@testerhoon28]

🙏🙏

[@thelayer5211]

Awesome

[@testerhoon28]

🙏

[@shashipatil9840]

Just wowww

[@testerhoon28]

🙏

[@amitprasad5471]

maa'm very nice content ..thanks again🙏🙏 please continue session.

[@testerhoon28]

🙏✌✌

[@amitprasad5471]

@@testerhoon28 ADF or ADB, please Ma'am iske upar bhi video bnye..

[@user-yp6ni1hz2r]

really superb

[@testerhoon28]

🙏

[@mahadevpatil9832]

good information

[@testerhoon28]

🙏

[@ladlyparashar5772]

Di please add one more thing in next video what is performance tuning and how to optimize it 🙏

[@nikitaghate9837]

Very nice explanation..easy to understand 😊😊😊thank you can you please make automation vedio

[@testerhoon28]

thank you 🙏

[@ladlyparashar5772]

Very useful video thankyou Will you make a video on most useful Unix commands for ETL testing and how to see log files.. Thankyou in advance

[@testerhoon28]

To check log files i have already created one vdo long time back.. winscp... pls chk that... will make vdo on unix soon.. 🙏

[@RakeshKumar-ql6oi]

please upload the videos in English..your videos and explanation was good and more informative and helpful...

[@testerhoon28]

okay 🙏

[@ipsitapradhan1672]

Please make video for target to DWH video. I am waiting. It's really helpful.Thank u.

[@testerhoon28]

okay 👍

[@Suraj18may]

Apart from count,duplicate and column mapping what are the other things we will validate in the target table?

[@testerhoon28]

transformation logic, data validation, key validation etc..

[@VAR_tech]

Hi Mam, Target par hone wale ye Full Load and Incremental load ke baare me ek confusion hai? Jaise ki Target me Dimension and Fact Table hote hai? jab data incremental load me jata hai to vo dimension or fact table me kis tarah se load hote hai? jo dimension table me SCD2 agar hota hai to kya vo incremental load ka hi part hai?

[@testerhoon28]

ek load hone ke baad incremental load he hota hai dwh me... chahe wo dim table to ya fact table..

[@kiranharijan2809]

Madam kindly make video on bug, how to follow up once it is raised.

[@testerhoon28]

ok👍

[@ankushkale616]

Please share how to do unit testing in SSIS

[@raghuteja-kr2ym]

could u try to explain how to understand mapping document with real time examples, it would help me to more understand about the mapping document Thanks in advance

[@testerhoon28]

okay 👍

[@akshayr6281]

Hi , an interviewer asked me "in your project at which stage SCD type 2 is implemented. Whether its SRC - Landing, OR Landing to Staging OR Staging to DW zone..?" could you please help

[@testerhoon28]

from staging to dwh , scd type 2 implemented ..

[@akshayr6281]

@@testerhoon28 thank you very much.. :)

[@VikramSingh-st8jd]

Hi Please , prepare a vedio for Truncate & Load , Streaming, Incremental , Historical loads. What are the different types of loads😅??

[@testerhoon28]

okay👍

[@prabhatgupta6415]

Hello please provide us the script if possible. One more request if u could bring some videos on performance testing when ETL migration happens. My team has asked me to get some metrics regarding this, if u could help me out.

[@dineshsolanki2022]

Complex se complex source sql query likhne ka tarika Complex Target Query likhne ka tarika Or dono complex Query ko kaise validate karte he ….Please Video bannayiye iss par

[@testerhoon28]

Sure 👍

[@akshaymulmule5042]

Could you please provide managerial round Questions

[@testerhoon28]

okay 👍🙏

[@1991rajnish]

Hi, can you share frequently asked questions for 5 years experience

[@testerhoon28]

okay 🙏🙏

[@1991rajnish]

@@testerhoon28 Tomorrow I have very important interview, can you share some links or documents.Thanks!!

[@prajakta887]

muze 2nd point nh samja minus query wala - select col1, col2 from stage (source - stage )(stage-source) ye kaise minus krenge from source

[@ajitdhangnawar5583]

First we can validate source minus target then we are validate target minus source

[@ankushkale616]

How to become etl data warehouses tester

[@testerhoon28]

okay 🙏

[@MrSumanth288]

Hi Mam, Also pls upload videos in English.

[@testerhoon28]

okay 🙏

[@vyshnavib8023]

Pls make videos in english🙏 sis

[@testerhoon28]

okay 🙏