DS Plug-In documentation for Oracle OCI Load Stage says:
Automatic Mode:
"The stage populates the Oracle database immediately after loading the source data."
1-Does "immediately after loading the source data" means that the data is first loaded onto a flat file and then written to Oracle table? (But that means writing twice to disk and more time consuming, just like Manual Mode, but automatically.)
2-Or should it be "immediately after extracting the source data", but then what would be the difference between the OCI stage and OCI Load Stage, because that too inserts the data immediately.
After the above line DS OCI Load Plug-In documentation also says:
"Automatic data loading occurs when the DataStage server resides on the same system as the Oracle server or when the Oracle server is remote and has the same operating system as the DataStage server."
But on Page 7, it says:
"Automatic (immediate mode). The stage populates an Oracle database immediately after loading the source data. Automatic data loading can occur only when the DataStage server resides on the same system as an Oracle server."
3-Which one is correct? Can the Oracle server be remote with same OS or does it have to be local to the DS Server?
Thanks
Oracle OCI Load Stage Automatic Mode & Plug-In Documenta
Moderators: chulett, rschirm, roy
1 - No, you stream data into the stage as quickly as you can and it 'loads' it into the database. Only in Manual mode is data landed.
2 - Perhaps 'immediately upon receiving the source data" ? OCI and OCI Load use two different mechanisms. The former are normal inserts same as you would from sqlplus, the latter hooks directly into the sqlldr API and implements a streaming direct path load.
3 - You can load to remote databases - I'm doing one right now.![Wink :wink:](./images/smilies/icon_wink.gif)
2 - Perhaps 'immediately upon receiving the source data" ? OCI and OCI Load use two different mechanisms. The former are normal inserts same as you would from sqlplus, the latter hooks directly into the sqlldr API and implements a streaming direct path load.
3 - You can load to remote databases - I'm doing one right now.
![Wink :wink:](./images/smilies/icon_wink.gif)
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers