August 10, 2009 at 9:18 am
Hi All!
the case:
-4 DB2/400 systems in 4 countries.
the need:
-Build a centralised DW having all the details of the tables.
the target:
-DW in MS SQL2008, and the tool is COGNOS 8.4
the problem:
-SSIS speeds with the MS OLE DB provider (which the fastest among ibm ole db and odbc) are not acceptable, although it is not a problem of SSIS but the VPNs'
the solution:
ALTERNATE METHOD of getting the data FASTER..
I am open to ideas...:-)
NO transformation of the data at this stage. It will be done at a later stage after the transfer....
thanks
Elias
August 10, 2009 at 3:40 pm
You might try dumping to flat files, zipping them, copying them to the DW server, unzipping, and then importing.
August 10, 2009 at 10:36 pm
That was exactly the solution I was going to suggest right up until I read your response...
CEWII
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply