loading of 100 dBase IV files into a single fact table, in a
Posted: Tue Jul 10, 2001 6:36 am
Dear All,
I have to load about 100 dBase IV file into a single fact table, how can I achieve it in a single job. This has been a problem, since extraction of dBase IV files require an ODBC stage, and the column derivation has information about the specific dBASE file. Has anyone every tried this, is there any alternative way
Regards,
Vivek Pandey _______________________________________________________
Consultant - Business Intelligence
SONATA SOFTWARE LTD.
193, R.V. Road,
Basavangudi,
Bangalore - 560004 INDIA
Voice: 91-80-6567492/6/7, 6561063/4/7, 6562068, 6568495
Cell: 91-98450-24394
Fax: 91-80-6567487
Web: http://www.sonata-software.com
Alt. email:viv_pan@usa.net _______________________________________________________
I have to load about 100 dBase IV file into a single fact table, how can I achieve it in a single job. This has been a problem, since extraction of dBase IV files require an ODBC stage, and the column derivation has information about the specific dBASE file. Has anyone every tried this, is there any alternative way
Regards,
Vivek Pandey _______________________________________________________
Consultant - Business Intelligence
SONATA SOFTWARE LTD.
193, R.V. Road,
Basavangudi,
Bangalore - 560004 INDIA
Voice: 91-80-6567492/6/7, 6561063/4/7, 6562068, 6568495
Cell: 91-98450-24394
Fax: 91-80-6567487
Web: http://www.sonata-software.com
Alt. email:viv_pan@usa.net _______________________________________________________