table schema change & data migration

[sudheer_nm]

Hi Guys,
I have to migrate data from Informix(6.x) to Oracle(9.x) but some of the tables in Oracle9i contains additional field.
I got the control and data files from informix and planning to import this in oracle using sql loader.
My doubts are:-
(1) How can i specify the data for the new fields in the table because the data file dosn't contain this values. Initially i thought of manually editing the data file for adding new data but this won't work out if the number of records are more.
(2) Should order of field in table is a matter for sql loader?
Could any one pls help me out.
Regards,
Sudheer

[adewri]

Hi

i would suggest that for tables having extra fields, just load data into some dummy user... then just do ITAS(insert into table as select)
to the actual user from the dummy user

HTH