InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
Explain how ETL is used in data migration projects. |
|
Answer» Data migration projects commonly use ETL tools. As an example, if the organization managed the data in Oracle 10g earlier and now they want to MOVE to SQL Server cloud database, the data will need to be migrated from Source to Target. ETL tools can be very HELPFUL for carrying out this type of migration. The user will have to spend a lot of TIME writing ETL code. The ETL tools are therefore very useful since they make CODING simpler than P-SQL or T-SQL. Hence, ETL is a very useful process for data migration projects. |
|