Thanks for your sub. Please check out my Database Normalization tutorials with multiple examples at the link, kzfaq.info/sun/PLc3SzDYhhiGXDgSwZxhNUmCYX7uAFN1Uu
@j.subbareddy27817 ай бұрын
Hi, Do u have any videos for data migration testing scenarios where source as oracle db & target as cloud ?
@QA17 ай бұрын
I should have the data migration testing scenarios, but I am not able to recollect the exact video, because I have uploaded more than 300 videos. But, here are the main scenarios (from my notes) for a successful transition from Oracle DB to the cloud. I hope that these help you: - Test comprehensive profiling of source data in Oracle DB to understand data types, constraints, and relationships. - Verify the compatibility of Oracle DB data with the target cloud platform. - Validate the accuracy of data mapping between Oracle DB and the cloud. - Confirm the success of data transformations during the migration process. - Verify that data integrity is maintained during the migration. - Confirm consistency between source and target data, including primary keys and unique constraints. - Ensure that the target cloud database schema matches the structure of the source Oracle DB. - Validate the creation of tables, indexes, and constraints. - Conduct data quality checks to identify anomalies or discrepancies. - Verify the accuracy of migrated data by comparing sample records. - Confirm the compatibility of the migrated data with the specific cloud database service (e.g., AWS RDS, Azure SQL Database, Google Cloud SQL). - Validate the support for Oracle data types in the chosen cloud platform. - Test the performance of data retrieval and storage in the cloud environment. - Ensure scalability by testing with varying data volumes. - Verify the implementation of data encryption during transit and at rest. - Validate access controls to ensure only authorized users can interact with the migrated data. - Develop automated scripts to validate large datasets efficiently. - Run regression tests to ensure ongoing data accuracy after subsequent migrations.
@chandrikak33437 жыл бұрын
Inder , Thanks for all the videos that you have posted ! They are very informative . Are there any means at all to get in touch with you directly as i have few questions on a urgent ongoing project .. I'd like your advice on that . ( Wont be able to discuss project details on this platform considering client conditions ).
@QA17 жыл бұрын
Sure, Chandrika. You can send your questions to me in Google Plus at plus.google.com/+InderPSingh
@divyayadav83007 жыл бұрын
is ETL used only for Data Migration?
@QA17 жыл бұрын
In computer science, ETL is an architecture pattern. Apart from data migration, it is also used in data interchange between two systems or data processing. But data migration is the main application of the ETL process.
@dineshnikam59033 жыл бұрын
Yes
@dineshnikam59033 жыл бұрын
We can use XML, Jason
@nishitatoshi2 жыл бұрын
What tool do you use to test Migration and ETL??
@QA12 жыл бұрын
In order to test Migration and ETL, Informatica is a popular tool.
@PrithvirajSahoo7 жыл бұрын
sir please do something about sound/mic. its too low and not audible properly.
@QA17 жыл бұрын
Sorry to know that you faced an issue. Did you try increasing the volume (in KZfaq player, Windows speakers icon and laptop/ headphones)? On my system, I was able to hear it okay at about 60% of my headphone volume. But thank you for letting me know. I will try and boost the volume from the next video.
@PrithvirajSahoo7 жыл бұрын
Software and Testing Training Yes Sir i did! But still voice was not audible. That is why thought of notifying you soon. Anyways I simply admire and follow your tutorials a lot. Thanks.
@QA17 жыл бұрын
Thanks, Prithviraj. Appreciate it. I have added English subtitles to this video. You can see the spoken text if you click Cc in the KZfaq player.
@PrithvirajSahoo7 жыл бұрын
Software and Testing Training Yes sir! Now it's better. Please try to add subtitles in each video from now onwards. Thank you very much for your time. And yes sir, forgot to mention earlier that Happy Holi. :)
@QA17 жыл бұрын
Hi Prithviraj, I have been busy adding and editing subtitles the last couple of months. You will find that a majority of my videos have subtitles now. Click Cc button in the KZfaq player to see subtitles in English. Thank you.