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

Пікірлер: 135

  • @Kish291
    @Kish291 Жыл бұрын

    Your really great personality😊

  • @testerhoon28

    @testerhoon28

    Жыл бұрын

    thank u 🙏

  • @Financialgroup0212
    @Financialgroup0212 Жыл бұрын

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

  • @testerhoon28

    @testerhoon28

    Жыл бұрын

    thank you 🙏

  • @lokeshankamreddi1626
    @lokeshankamreddi1626 Жыл бұрын

    Wonderful videos your uploading 🙏🙏🙏❤️

  • @sonipk30
    @sonipk308 күн бұрын

    Thank u for video....

  • @emmanuelg8375
    @emmanuelg8375 Жыл бұрын

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

  • @testerhoon28

    @testerhoon28

    Жыл бұрын

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

  • @SRI-uw5hl
    @SRI-uw5hl Жыл бұрын

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

  • @testerhoon28

    @testerhoon28

    Жыл бұрын

    thank you sir.. it means a lot 🙏🙏

  • @sarangmate1594
    @sarangmate1594 Жыл бұрын

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

  • @testerhoon28

    @testerhoon28

    Жыл бұрын

    thank you 🙏😊

  • @suryakantkumar1168

    @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

    @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

    @nageshmudila7653

    Жыл бұрын

    Please tell in english please

  • @aarizkhan9471
    @aarizkhan94719 ай бұрын

    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

    @testerhoon28

    9 ай бұрын

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

  • @alagandulasandeep9148
    @alagandulasandeep9148 Жыл бұрын

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

  • @testerhoon28

    @testerhoon28

    Жыл бұрын

    thank you thank you thank you 🙏😇

  • @manasenamanakarthavyam4150
    @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

  • @hsreenivasulu1457
    @hsreenivasulu1457 Жыл бұрын

    great explanation each concept is very clear

  • @testerhoon28

    @testerhoon28

    Жыл бұрын

    thank you 🙏

  • @madhukiran3020
    @madhukiran3020 Жыл бұрын

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

  • @testerhoon28

    @testerhoon28

    Жыл бұрын

    Will try to include subtitle... 🙏

  • @amitprasad5471
    @amitprasad5471 Жыл бұрын

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

  • @testerhoon28

    @testerhoon28

    Жыл бұрын

    sure will try to upload ASAP 🙂

  • @nilamnavgire2227
    @nilamnavgire2227 Жыл бұрын

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

  • @surajshrirao-lv2pm
    @surajshrirao-lv2pm2 ай бұрын

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

  • @testerhoon28

    @testerhoon28

    2 ай бұрын

    Thank you 🙏

  • @garimellakeerthi7124
    @garimellakeerthi71247 ай бұрын

    Nice explanation mam❤

  • @maheshkshirsagar6361
    @maheshkshirsagar63618 ай бұрын

    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

    @testerhoon28

    8 ай бұрын

    thank you 🙏

  • @manasenamanakarthavyam4150
    @manasenamanakarthavyam4150 Жыл бұрын

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

  • @testerhoon28

    @testerhoon28

    Жыл бұрын

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

  • @manasenamanakarthavyam4150

    @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

  • @coding7241
    @coding7241 Жыл бұрын

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

  • @testerhoon28

    @testerhoon28

    Жыл бұрын

    okay 👍

  • @suryakantkumar1168
    @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

    @testerhoon28

    Жыл бұрын

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

  • @BillionDollerDream
    @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

    @vishalkoundal5008

    4 ай бұрын

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

  • @user-id3ie3oj8g
    @user-id3ie3oj8g Жыл бұрын

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

  • @testerhoon28

    @testerhoon28

    Жыл бұрын

    ok... 👍

  • @akshayyamkar
    @akshayyamkar Жыл бұрын

    nice one

  • @rohitdewangan27
    @rohitdewangan27 Жыл бұрын

    beautifully explained

  • @testerhoon28

    @testerhoon28

    Жыл бұрын

    thank you 🙏

  • @neharoy6859
    @neharoy6859 Жыл бұрын

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

  • @rickybawa7264
    @rickybawa72644 ай бұрын

    Good Explanation😊

  • @rickybawa7264

    @rickybawa7264

    4 ай бұрын

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

  • @kumarrajiv2821
    @kumarrajiv2821 Жыл бұрын

    Can you please make video on Unix level validation

  • @testerhoon28

    @testerhoon28

    Жыл бұрын

    okay 👍

  • @sonalibansode7129
    @sonalibansode7129 Жыл бұрын

    thank you mam

  • @testerhoon28

    @testerhoon28

    Жыл бұрын

    🙏🙏

  • @mcadengineer6638
    @mcadengineer6638 Жыл бұрын

    Nice video 👍

  • @testerhoon28

    @testerhoon28

    Жыл бұрын

    thank you 🙏

  • @prasannalakshmi8351
    @prasannalakshmi8351 Жыл бұрын

    Thank u so much mam got offer letter from accenture

  • @testerhoon28

    @testerhoon28

    Жыл бұрын

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

  • @prasannalakshmi8351

    @prasannalakshmi8351

    Жыл бұрын

    Yes mam your videos helped me lot

  • @nuthanab7698

    @nuthanab7698

    Жыл бұрын

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

  • @RakeshKumar-ql6oi
    @RakeshKumar-ql6oi Жыл бұрын

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

  • @testerhoon28

    @testerhoon28

    Жыл бұрын

    okay will either include subtitle or make in english 🙏

  • @siddharthtuplondhe3043
    @siddharthtuplondhe30435 ай бұрын

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

  • @testerhoon28

    @testerhoon28

    5 ай бұрын

    Okay

  • @ajsahu10
    @ajsahu107 ай бұрын

    How to perform join validation in etl

  • @suryakantkumar1168
    @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

    @testerhoon28

    Жыл бұрын

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

  • @112divya
    @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

    @testerhoon28

    Жыл бұрын

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

  • @Creations177
    @Creations177 Жыл бұрын

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

  • @testerhoon28

    @testerhoon28

    Жыл бұрын

    yes, now started explaining in english... 🙏

  • @venkysfdcqa
    @venkysfdcqa Жыл бұрын

    your testing is excellent but expecting English language

  • @testerhoon28

    @testerhoon28

    Жыл бұрын

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

  • @sunilkoppad8103
    @sunilkoppad8103 Жыл бұрын

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

  • @testerhoon28

    @testerhoon28

    Жыл бұрын

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

  • @ITmindz
    @ITmindz9 ай бұрын

    Mast

  • @testerhoon28

    @testerhoon28

    9 ай бұрын

    🙏

  • @soothsayer8500
    @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

    @testerhoon28

    Жыл бұрын

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

  • @chetan8872
    @chetan8872 Жыл бұрын

    please make a video on ETL realtime project,

  • @testerhoon28

    @testerhoon28

    Жыл бұрын

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

  • @riteshkumarsingh3020
    @riteshkumarsingh3020 Жыл бұрын

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

  • @testerhoon28

    @testerhoon28

    Жыл бұрын

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

  • @dramatv9122

    @dramatv9122

    Жыл бұрын

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

  • @testerhoon28

    @testerhoon28

    Жыл бұрын

    @@dramatv9122 okay 👍

  • @neharoy6859
    @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?

  • @trivenipatil7887
    @trivenipatil7887 Жыл бұрын

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

  • @testerhoon28

    @testerhoon28

    Жыл бұрын

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

  • @topdown5138
    @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

    @testerhoon28

    Жыл бұрын

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

  • @akshaymulmule5042
    @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

    @testerhoon28

    Жыл бұрын

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

  • @akshaymulmule5042

    @akshaymulmule5042

    Жыл бұрын

    @@testerhoon28 ok thanks mam

  • @kiranharijan2809
    @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

    @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

    @kiranharijan2809

    Жыл бұрын

    @@testerhoon28 what is conditional sign off?

  • @priyajamuna5403
    @priyajamuna5403 Жыл бұрын

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

  • @testerhoon28

    @testerhoon28

    Жыл бұрын

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

  • @thelayer5211
    @thelayer5211 Жыл бұрын

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

  • @testerhoon28

    @testerhoon28

    Жыл бұрын

    hello... haan 👍

  • @ritukhulve8107
    @ritukhulve8107 Жыл бұрын

    Hello mama

  • @prasannalakshmi8351
    @prasannalakshmi8351 Жыл бұрын

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

  • @testerhoon28

    @testerhoon28

    Жыл бұрын

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

  • @vishalkoundal5008
    @vishalkoundal50084 ай бұрын

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

  • @testerhoon28

    @testerhoon28

    4 ай бұрын

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

  • @vishalkoundal5008

    @vishalkoundal5008

    4 ай бұрын

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

  • @lokeshankamreddi1626
    @lokeshankamreddi1626 Жыл бұрын

    Please upload SQL videos 🙏

  • @testerhoon28

    @testerhoon28

    Жыл бұрын

    ok 🙏

  • @thelayer5211
    @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

    @testerhoon28

    Жыл бұрын

    for that we use automation tool...

  • @thelayer5211

    @thelayer5211

    Жыл бұрын

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

  • @sunilkoppad8103
    @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

    @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

    @sunilkoppad8103

    Жыл бұрын

    Thank you

  • @KISHOREKUMAR-mu3xo

    @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
    @thelayer5211 Жыл бұрын

    Didi aap log files validation pe ek video banao na plz

  • @testerhoon28

    @testerhoon28

    Жыл бұрын

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

  • @thelayer5211

    @thelayer5211

    Жыл бұрын

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

  • @rajeshdronavalli3636
    @rajeshdronavalli3636 Жыл бұрын

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

  • @testerhoon28

    @testerhoon28

    Жыл бұрын

    okay 👍

  • @muhammadyasir8880
    @muhammadyasir888010 ай бұрын

    Partition by Salary 😢

  • @udaysairammuthyala2534
    @udaysairammuthyala2534 Жыл бұрын

    Please explain in English. We are from south.

  • @testerhoon28

    @testerhoon28

    Жыл бұрын

    okay 🙏

  • @prasannalakshmi8351
    @prasannalakshmi8351 Жыл бұрын

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

  • @testerhoon28

    @testerhoon28

    Жыл бұрын

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

  • @prasannalakshmi8351

    @prasannalakshmi8351

    Жыл бұрын

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

  • @testerhoon28

    @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

    @prasannalakshmi8351

    Жыл бұрын

    Joining date is 16th January mam

  • @testerhoon28

    @testerhoon28

    Жыл бұрын

    @@prasannalakshmi8351 okay... all the best

  • @ritukhulve8107
    @ritukhulve8107 Жыл бұрын

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

  • @testerhoon28

    @testerhoon28

    Жыл бұрын

    Email me @ tmadamji@gmail.com , I will add u in WhatsApp group

  • @ajithajith2188
    @ajithajith21886 ай бұрын

    hi i need etl tsetng training how can we contact you

  • @pravinwaghmare9757
    @pravinwaghmare9757 Жыл бұрын

    Thanks mam

  • @testerhoon28

    @testerhoon28

    Жыл бұрын

    🙏🙏

Келесі