Record Generation [message #397086] |
Wed, 08 April 2009 17:45  |
Krishna_dev
Messages: 32 Registered: May 2007
|
Member |
|
|
This is my scenario.
I am importing records from SQL Server to an Oracle staging table for a journal import.
For each record imported I need to generate 4 entries only.
The columns being imported from SQL Server are as follows:
COMPANY := 0052 (Constant)
ACCOUNT := 6220700 (Constant)
AMOUNT := Always changes.
INVOICE := Always changes.
So a typical incoming record would be like 0052||6220700||$7000||INVOICE#01.So given the rules
above I would need to generate 3 other records as follows from the orignal record imported as
show below.So once this record is processed I would have the following 4 rows in the oracle
table.
COMPANY||ACCOUNT||AMOUNT||INVOICE
0052 ||6220700||$7000 ||INVOICE#01
0052 ||1664000||$7000 ||INVOICE#01
0002 ||6220700||$7000 ||INVOICE#01
0002 ||1664000||$7000 ||INVOICE#01
Could anyone tell me how I can create these records.
|
|
|
|
Re: Record Generation [message #397091 is a reply to message #397087] |
Wed, 08 April 2009 21:20   |
Krishna_dev
Messages: 32 Registered: May 2007
|
Member |
|
|
>Create the needed data in SQL Server before dumping to a flat file, access the flat file as an external table and INSERT into the real & final Oracle table.
Access to the SQL Server Database is limited to "Select" queries only, so we cannot create and records within that database before importing to Oracle.
|
|
|
|
Re: Record Generation [message #397112 is a reply to message #397091] |
Thu, 09 April 2009 01:12  |
Frank
Messages: 7901 Registered: March 2000
|
Senior Member |
|
|
Krishna_dev wrote on Thu, 09 April 2009 04:20 | >Create the needed data in SQL Server before dumping to a flat file, access the flat file as an external table and INSERT into the real & final Oracle table.
Access to the SQL Server Database is limited to "Select" queries only, so we cannot create and records within that database before importing to Oracle.
|
If you can select, you can output anything in any form.
|
|
|