Is it a one time process ? Or do you want to do it on a daily basis ? Or do you want it near 'real-time' ?
For the first two cases, you can use EXPORT on OLTP and IMPORT/LOAD on the OLAP ...
For the third case, you can use DB2 Replication ..
You will need to provide more details for people here to provide more information
Originally posted by sarah28
My OLTP database lies in DB2/LINUX and my OLAP database lies in DB2/NT.Now,I need to transfer data from just some specific columns of tables from OLTP to OLAP.How do I go abt it?Any ideas??
Last edited by sathyaram_s; 07-16-03 at 04:35.
Visit the new-look IDUG Website , register to gain access to the excellent content.