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.
Thanks for your sub. Please check out my Database Normalization tutorials with multiple examples at the link, th-cam.com/play/PLc3SzDYhhiGXDgSwZxhNUmCYX7uAFN1Uu.html
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.
Sorry to know that you faced an issue. Did you try increasing the volume (in TH-cam 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.
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.
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. :)
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 TH-cam player to see subtitles in English. Thank you.
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 ).
Thank you. Much simpler explanations.
Hi, Do u have any videos for data migration testing scenarios where source as oracle db & target as cloud ?
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.
Thanks it is very easy understandable.
Thanks for your sub. Please check out my Database Normalization tutorials with multiple examples at the link, th-cam.com/play/PLc3SzDYhhiGXDgSwZxhNUmCYX7uAFN1Uu.html
What tool do you use to test Migration and ETL??
In order to test Migration and ETL, Informatica is a popular tool.
Thanks
Thank you sir
is ETL used only for Data Migration?
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.
Yes
We can use XML, Jason
sir please do something about sound/mic. its too low and not audible properly.
Sorry to know that you faced an issue. Did you try increasing the volume (in TH-cam 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.
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.
Thanks, Prithviraj. Appreciate it. I have added English subtitles to this video. You can see the spoken text if you click Cc in the TH-cam player.
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. :)
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 TH-cam player to see subtitles in English. Thank you.
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 ).
Sure, Chandrika. You can send your questions to me in Google Plus at plus.google.com/+InderPSingh