Migration of databases from SQL to Oracle using repotools, do we need to reconstruct data warehouse
I am planning to migrate database vendor of CLM 5.0.2 from SQL Server 2012 to Oracle Db 12c Release 1. Current database server is hosted on windows server, target database server will be hosted on linux server. I will be referring below link by IBM for database migration.
I was going through link and noticed that repotools commands are executed for every application to generate ".tar" file but I could not see command to generate ".tar" file for data warehouse, I want to know if I have to reconstruct datawarehouse all over again after databases are migrated to oracle. If so to reconstruct data warehouse do I have to run ETL jobs with full load so that it will feed data to data warehouse. Please let me know correct way to migrate databases.