What is the Data migration process?
1. Requirements will come as RSD (Requirement Specification Document)
2. RSD document will be shared with Both dev and SIT team
3. Dev Team will start the Developments, SIT (our team) will start with the test plan and test case preparation, mapping document preparations.
The reason for the source stage is
Files can be a data source
• We can load the file data into the database table, it will happen in the source stage
Data may from multiple databases
• 10 tables have to be migrated then
• 5 of them coming from MySQL database
• 5 of them coming from the oracle database
• We can merge all into the source stage
Source stage is not needed, when we're receiving cleansed data and data is from single source
No cleansed data is
Like internet provided in the 100mbps of speed and limit of 1000 GB
Like internet provided in the 100M of speed and limit of 1000G
Like internet provided in the 100M- 1000 GB
This data has to go to target as
For speed, column 100
For limit column 1000
1. If Source is a file then, the Source stage will be there
2. In this case file data will load to the source stage environment
3. From the Source stage data will be migrated to the target stage
4. In that target stage data has to be validated by the ETL testers
5. If the ETL tester is given a green signal, then(sign off), data will be migrated to Target DB.
No comments:
Post a Comment