loading of 100 dBase IV files into a single fact table, in a
loading of 100 dBase IV files into a single fact table, in a
This is a topic for an orphaned message.
Yes, I do this all the time.
Out of time just now, Ill try and post a reply for you tonight.
In short, you cant easily do it in one job unless you want to start writing basic code. It can be done with a couple of jobs.
Later...
-----Original Message-----
From: Vivek Pandey. [SMTP:vive@sonata-software.com]
Sent: Tuesday, July 10, 2001 4:36 PM
To: datastage-users@oliver.com
Subject: loading of 100 dBase IV files into a single fact table, in a
sing le job
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 _______________________________________________________
*************************************************************************
This e-mail and any files transmitted with it may be confidential and are intended solely for the use of the individual or entity to whom they are addressed. If you have received this e-mail in
error, please notify the sender by return e-mail, and delete this e-mail from your in-box. Do not copy it to anybody else
*************************************************************************
Out of time just now, Ill try and post a reply for you tonight.
In short, you cant easily do it in one job unless you want to start writing basic code. It can be done with a couple of jobs.
Later...
-----Original Message-----
From: Vivek Pandey. [SMTP:vive@sonata-software.com]
Sent: Tuesday, July 10, 2001 4:36 PM
To: datastage-users@oliver.com
Subject: loading of 100 dBase IV files into a single fact table, in a
sing le job
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 _______________________________________________________
*************************************************************************
This e-mail and any files transmitted with it may be confidential and are intended solely for the use of the individual or entity to whom they are addressed. If you have received this e-mail in
error, please notify the sender by return e-mail, and delete this e-mail from your in-box. Do not copy it to anybody else
*************************************************************************