Hello,
Currently I work on loading an Oracle table from a flat file separated by ";". My Ksh script launches the sql loader script and load my table after controls and also generates logs and Bades. Loading it done daily through an ETL that starts loading. For more performance and to keep my data since my script made to cancel replace wish:
- First, my data loaded into a temporary table.
- Then, if the OK controls all the lines are loaded into my temporary table, I charge in the official table, otherwise I kO not charge anything in my official table.
So my question:
- Is-that it would be possible to load data Ksh an OK table to another (that is to say: copy data from a table tempo OK in the official table) or make a copy a table in ksh?
- Or in sql loader check the number line in a file.txt if = number of loaded data line in the table in this case load me in the table offici
Thank you in advance for your réponse.Bonjour,
Currently I work on loading an Oracle table from a flat file separated by ";". My Ksh script launches the sql loader script and load my table after controls and also generates logs and Bades. Loading it done daily through an ETL that starts loading. For more performance and to keep my data since my script made to cancel replace wish:
- First, my data loaded into a temporary table.
- Then, if the OK controls all the lines are loaded into my temporary table, I charge in the official table, otherwise I kO not charge anything in my official table.
So my question:
- Is-that it would be possible to load data Ksh an OK table to another (that is to say: copy data from a table tempo OK in the official table) or make a copy a table in ksh?
- Or in sql loader check the number line in a file.txt if = number of loaded data line in the table in this case load me in the table offici
Thank you in advance for your answer.
Moderator's Comments:
|
|
Please edit this post, remove the duplicate text and give a clearer specification of what is requested! Don't use unusual abbreviations (Bades? I kO? offici?) and be decently more verbose when explaining what needs to be done.
|
|