ETL testing End to End Process with Live Data | Flat File , Mapping Sheet, Test Case, Excel Validatn

ETL testing End to End Process with Live Data | Flat File , Mapping Sheet, Test Case, Excel Validate
How to Load data through Flat File
What all parameters are defined in Mapping Sheet
ETL testing test scenarios and Test Cases
How to Validate source and Target Data in ETL testing Through Excel
Blog - www.testerhoon.com

[@Kish291]

Your really great personality😊

[@testerhoon28]

thank u 🙏

[@sarangmate1594]

Weekend pr bhi aap time nikalkar video post krti ho. Aur hume real time terminology clear ho jati hai. Thank you mam

[@testerhoon28]

thank you 🙏😊

[@suryakantkumar1168]

Mam aap bahut acha samjhate hai. Mam apse request hai ETL TESTING mein jo real kaam karna hota hai uska video banaiye explaining ETL TESTER WORK AND RESPONSIBILITY FROM END TO END ANY PROJECT ANY DOMAIN JISSE HUME INTERVIEW DETE WAQT HELP HO please🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏

[@suryakantkumar1168]

🙏🙏🙏🙏🙏🙏🙏Mam aap bahut acha samjhate hai. Mam apse request hai ETL TESTING mein jo real kaam karna hota hai uska video banaiye explaining ETL TESTER WORK AND RESPONSIBILITY FROM END TO END ANY PROJECT ANY DOMAIN JISSE HUME INTERVIEW DETE WAQT HELP HO please🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏Mam aap bahut acha samjhate hai.

[@nageshmudila7653]

Please tell in english please

[@Financialgroup0212]

fantastic mam. i have gone through your 3 to 4 videos. its really increasing our knowledge. Thank you!

[@testerhoon28]

thank you 🙏

[@lokeshankamreddi1626]

Wonderful videos your uploading 🙏🙏🙏❤️

[@madhukiran3020]

hi , your real time teaching is awesome. can you try in english. it will be helpful for many

[@testerhoon28]

Will try to include subtitle... 🙏

[@emmanuelg8375]

Excellent mam. Very nice explanation mam. We expect more videos. Your videos only source for me to learn...

[@testerhoon28]

thank you 🙏 stay tuned every weekend i do upload vdos...

[@SRI-uw5hl]

You are an excellent teacher........superb...

[@testerhoon28]

thank you sir.. it means a lot 🙏🙏

[@aarizkhan9471]

Thanx alot mam im following your all videos to crack mnc companies interviews all your videos helping us alot to gain real time knowledge.and yes,your voice is so pure n innocent.

[@testerhoon28]

Thank you so much @aarizkhan for your kind words 🙏🙏😊

[@amitprasad5471]

Very Nice content 👍👍 Please Please try to upload next video as soon. I m learning from your. Thanks 🙏🙏

[@testerhoon28]

sure will try to upload ASAP 🙂

[@manasenamanakarthavyam4150]

Thanks for making the videos which are useful to us and please make a video for how to validate the missing record Ex.. millions records are there in that if any record is missing how will you find that what are the things you need to validate ...and what basis will validate to find out that missing or error records Thing is should not lose any data. file vs DAL [data acquisition layes ] How to validate Please make a vedio more and more and please don't take more time to upload

[@alagandulasandeep9148]

Excellent Excellent Excellent Excellent...thank you very much medam, please do more videos....thank you 😀 😊

[@testerhoon28]

thank you thank you thank you 🙏😇

[@maheshkshirsagar6361]

Nice explanation of ETL testing videos, but with python ETL testing, please make the video series. And one more request, please upload another series like shell scripting, stored procedure. It's definitely helping to others to learning ETL testing process in simple and lucid language. Thank you so much. Keep it up.

[@testerhoon28]

thank you 🙏

[@surajshrirao-lv2pm]

superb teaching I watch all video it was a nice teaching with all basic concept. Nice teaching

[@testerhoon28]

Thank you 🙏

[@hsreenivasulu1457]

great explanation each concept is very clear

[@testerhoon28]

thank you 🙏

[@suryakantkumar1168]

Mam aap bahut acha samjhate hai. Mam apse request hai ETL TESTING mein jo real kaam karna hota hai uska video banaiye explaining ETL TESTER WORK AND RESPONSIBILITY FROM END TO END ANY PROJECT ANY DOMAIN JISSE HUME INTERVIEW DETE WAQT HELP HO please🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏

[@testerhoon28]

thank you 🙏 ... aap meri end to end wali video dekhiye... maine usme sab explain kar rakha hai... tester roles and responsibilities...

[@Nalinee01]

Thank u for video....

[@BillionDollerDream]

Thank you mam, can share some insights about.... 1) What is ETL automation? How is it done? 2) can you tell us some complex requirements you encountered in your organization and how you validated it(SQL query) It will be really helpful if you can make video about above two questions Thanks once again

[@vishalkoundal5008]

Yes Also want to know regarding the Etl automation. Do you have any idea how to do this? plz let me know.

[@garimellakeerthi7124]

Nice explanation mam❤

[@nilamnavgire2227]

u are best👌👌👌👌thank you 🙏can you send full etl testing

[@coding7241]

long live this channel..plz provide the csv files too

[@testerhoon28]

okay 👍

[@akshayyamkar]

nice one

[@manasenamanakarthavyam4150]

Your videos are very helpful that's y asking make on immediate bassis

[@testerhoon28]

thank you 🥰 ... yeah m trying to make regularly vdos... but i do not have much time 😰

[@manasenamanakarthavyam4150]

Thanks for making the videos which are useful to us and please make a video for how to validate the missing record Ex.. millions records are there in that if any record is missing how will you find that what are the things you need to validate ...and what basis will validate to find out that missing or error records Thing is should not lose any data. file vs DAL [data acquisition layes ] How to validate Please make a vedio more and more and please don't take more time to upload

[@user-id3ie3oj8g]

Thanks for video..please make video on etl testing on any cloud platform. .

[@testerhoon28]

ok... 👍

[@rohitdewangan27]

beautifully explained

[@testerhoon28]

thank you 🙏

[@mcadengineer6638]

Nice video 👍

[@testerhoon28]

thank you 🙏

[@rickybawa7264]

Good Explanation😊

[@rickybawa7264]

Hi, actually I need your help for Job ( ETL Tester)

[@RakeshKumar-ql6oi]

Please explain in English as I am from south... Your videos, explanation and content is good and more useful to us...

[@testerhoon28]

okay will either include subtitle or make in english 🙏

[@neharoy6859]

Can u pls make a video on list file like how can we create using unix command without doing it manually ?

[@suryakantkumar1168]

🙏🙏🙏🙏🙏🙏🙏Mam aap bahut acha samjhate hai. Mam apse request hai ETL TESTING mein jo real kaam karna hota hai uska video banaiye explaining ETL TESTER WORK AND RESPONSIBILITY FROM END TO END ANY PROJECT ANY DOMAIN JISSE HUME INTERVIEW DETE WAQT HELP HO please🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏Mam aap bahut acha samjhate hai.

[@testerhoon28]

thank you 🙏 ... aap meri end to end wali video dekhiye... maine usme sab explain kar rakha hai... tester roles and responsibilities...

[@prasannalakshmi8351]

Thank u so much mam got offer letter from accenture

[@testerhoon28]

many congratulation... i hope my videos has helped you... 🙏

[@prasannalakshmi8351]

Yes mam your videos helped me lot

[@nuthanab7698]

@@prasannalakshmi8351 hoii i have interview in accenture can you tell me the question dataware house etl testing Plz?

[@sonalibansode7129]

thank you mam

[@testerhoon28]

🙏🙏

[@kumarrajiv2821]

Can you please make video on Unix level validation

[@testerhoon28]

okay 👍

[@112divya]

Hi Madam.. Thanks for the very nice video and explanation. My requirement is something similar to validate data between many tables in databases (1000+). So do we have any free ETL tool for achieving the result.

[@testerhoon28]

As such no free tool, but to validate data you can use automation...

[@sunilkoppad8103]

Can you please make a video on - how to create a test data and temp table as a etl teser

[@testerhoon28]

ok, but that i have already explained in the vdo...

[@siddharthtuplondhe3043]

Mam ap ETL development MSBI SSIS ke test cases batayenge along with ETL testing .Thank you

[@testerhoon28]

Okay

[@ajsahu10]

How to perform join validation in etl

[@riteshkumarsingh3020]

Thank you mam, can you provide whole etl testing classes in hindi with SQL queries

[@testerhoon28]

earlier i was making video in hindi only... but majority of subscribers want in english ... so i started in english 🙏

[@dramatv9122]

@@testerhoon28 mam can u teach us more about sql and also please explain the future scope

[@testerhoon28]

@@dramatv9122 okay 👍

[@ITmindz]

Mast

[@testerhoon28]

🙏

[@trivenipatil7887]

As a tester how to learn azure data factory and data bricks ,can you make video on that

[@testerhoon28]

soon i will start uploading vdos on ADF and ADB...

[@soothsayer8500]

Do we need to develop and write query ourselves as ETL tester? Iam very bad at coding and not interested also. Cant a manual tester do ETL testing with zero technical knowledge?

[@testerhoon28]

yes , ETL tester should be very good in SQL... u shud know SQL if u want u bcm etl tester.. 🙏

[@akshaymulmule5042]

Mam if there is 1000000 record in flat file then how can we validate it. I mean some time excel might be hang .So what will be your approach to validate it

[@testerhoon28]

in that case we use automation tool to validate the record..

[@akshaymulmule5042]

@@testerhoon28 ok thanks mam

[@topdown5138]

hi, informatica ke completed jobs pe test cases and defect identification (like log file me errors identification etc) ki video bana sakte hai .. please

[@testerhoon28]

i am working on Azure... for that i can make vdo in cmg days..

[@kiranharijan2809]

Madam If any of the task is not completed then is it possible to extend sprint time? If yes then whom to request team leader or client?

[@testerhoon28]

that task will be moved in next sprint.. its not an issue... Mostly dev project manager or dev team lead drives the scrum calls

[@kiranharijan2809]

@@testerhoon28 what is conditional sign off?

[@neharoy6859]

1)how to load multiple files in informatica came in same time using unix?...Can someone pls help me with the answer 2)how to implement etl folder contains many files and in that need to load the oldest file in informatica how to see log files for specific date of 25th only but you are not getting the timestamp?

[@chetan8872]

please make a video on ETL realtime project,

[@testerhoon28]

As we are working on client machine, it wont be possible to show real time project...

[@venkysfdcqa]

your testing is excellent but expecting English language

[@testerhoon28]

Thank you...🙏Now i have started making vdo in english..

[@prasannalakshmi8351]

Mam do u know what Quality engineer senior Analyst do in Etl testing

[@testerhoon28]

all do same work... sql writing..requirement gathering and validation..

[@Creations177]

Great ,,,, but explain in English would help more

[@testerhoon28]

yes, now started explaining in english... 🙏

[@priyajamuna5403]

Mam please add subtitle or explain English am very grateful to you thank you!

[@testerhoon28]

ok, in nxt vdo i will try to add subtitle... 👍

[@thelayer5211]

Sister duplicate ke liye having count (*)>1 use krna tha

[@testerhoon28]

hello... haan 👍

[@lokeshankamreddi1626]

Please upload SQL videos 🙏

[@testerhoon28]

ok 🙏

[@ritukhulve8107]

Hello mama

[@vishalkoundal5008]

G8 session mam I mail you regarding the classes when will u start the batch kindly let me know plz

[@testerhoon28]

Thank you, I will let you know once a Batch will start

[@vishalkoundal5008]

Kindly start it ASAP mam.... Thxs for the reply

[@thelayer5211]

If we have millions of data in src CSV file as well as TRG file then how can we validation this data in Excel sheet

[@testerhoon28]

for that we use automation tool...

[@thelayer5211]

@@testerhoon28wt types of n how to validate partitioning in ETL???

[@sunilkoppad8103]

If we have 50 records in both source and target table.. if we use minus operator then we will get zero zero output in return.. if we use intersect operator then we will get 45 records in return... Why will this happen?

[@testerhoon28]

INTERSECT compares the data between tables and returns only the rows of data that exist in both tables. MINUS compares the data between tables and returns the rows of data that exist only in the first table you specify...

[@sunilkoppad8103]

Thank you

[@KISHOREKUMAR-mu3xo]

The answer is in both the tables there should be duplicates That's the reason intersect return only 45 common records from Both the tables ...as intersect removes the duplicates it displays unique common records from both the tables. Plz correct me if I am wrong

[@thelayer5211]

Didi aap log files validation pe ek video banao na plz

[@testerhoon28]

that i already made... pls check my old vdos🙏

[@thelayer5211]

@@testerhoon28 where it is...m unable to find...plz share video link 🙏

[@prasannalakshmi8351]

I need your continuous support for next days also please give me reply

[@testerhoon28]

okay tell me... I belive I always responded you...🙏

[@prasannalakshmi8351]

Yes mam I got Offer letter from accenture and I accepted it what next mam

[@testerhoon28]

@@prasannalakshmi8351 now u have to give client interview if they have not hired u for any specific project... else project KT will strt...

[@prasannalakshmi8351]

Joining date is 16th January mam

[@testerhoon28]

@@prasannalakshmi8351 okay... all the best

[@muhammadyasir8880]

Partition by Salary 😢

[@rajeshdronavalli3636]

Please use English subtitles those who don’t know Hindi language

[@testerhoon28]

okay 👍

[@udaysairammuthyala2534]

Please explain in English. We are from south.

[@testerhoon28]

okay 🙏

[@ritukhulve8107]

Can you share your contact details, i want to take classes

[@testerhoon28]

Email me @ [e-mail] , I will add u in WhatsApp group

[@ajithajith2188]

hi i need etl tsetng training how can we contact you

[@pravinwaghmare9757]

Thanks mam

[@testerhoon28]

🙏🙏