Unanswered: loading the data from application database to data warehouse.
I am almost new in Database.So,
I have appication database and Datawarehouse, both are on the same host.
I am loading the data static and permanent, I have no problem with this.
Now I want to change the DWH to the other host(host2). I am thinking to create DWH on host2 and one db for example NoSQL, load the dump from live to the NoSQL and from Nosql to DWH.
Is it correct?
could you suggest some loading techniques ?