ETL Testing | How to validate data from Source to Target

ETL Testing | How to Validate Source and Target data

It involve validating the entire data set in both the source and target tables using a minus query. Both source minus target and target minus source must be performed. If the minus query returns a value, this indicates that there are mismatched rows.

#etltesting
#dwh

Blog for more details -

[mudashivaprasad]

TQ nice explanation... Keep continue in making videos

[gullasridhar]

very crystal clear explanation very easy to understand, thank you

[pramodmaharana]

Very nice explanation Maam. Easy to understand. Thanks a lot

[suryakantkumar]

🙏🙏🙏🙏🙏🙏🙏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.

[idieojg]

Thanks for video...waiting for adf video

[krunalgaikwad]

very helpful thank u so much ma'am

[amolkalam]

Helpful video mam, I'm always waiting for U R next video..., Please upload next videos fast...

[udaykumarreddy]

How do we compare source as flat file Target is table can pls show end to end video

[bharatdialysis]

mam informatica me practical samjhaiye please aur informatica ka enterface ke bare bhi bataiye kis chiz ka kya function hai

[sridharmurari]

How to validate if all fields datatype are correct between source to target?

[francisfrancis]

Thanks you madam for clear explanation.. i have a general doubt. Is indepth SQL skill needed for etl testing or basic SQL knowledge is enough?

[sunilkoppad]

What is smoke and sanity testing as part of etl testing.
What is functional and non fictional testing as part of etl testing.
Please make video on this, they are asking these questions in most of the interviews.

[amitprasad]

Ma'am I follow your all video..
Please start with beginners 🙏🙏

[deveshpadgelwar]

How to coordinate dev team there is a no mapping document ?
Can you please elaborate mam ?

[prabhatgupta]

what if multiple tables are there in source and destination.. then how can we perform ?
;

[pavanabiradar]

HI Madam,
your teaching inspired me a lot. You have good career in teaching for college students.
Coming to cloud base technology yes it is v good S/w I can tell Present my organization not adopted but in market it is the trend how to get a job in other organization which is working on cloud my 2 interview have got failed because of azure knowledge need your suggestion.
Thank you for your time n video.

[manasenamanakarthavyam]

Can you please make a video for mapping logic and how to write scripts based on mapping document

[manasenamanakarthavyam]

If you find mismatch records then what are the further steps that have to follow
How to find those mismatch records

[Fix_Test]

Please make videos on ETL Testing full series

[sarangmate]

Mam if it is possible please upload sql, ETL & Unix questions for interview point of view....