Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between SQl Loader and OCI in datastage?
- 2 Answers
- 14951 Views
- CSC, I also Faced
- E-Mail Answers
Answer Posted / andy vaidya
SQL Loader (sqlldr) is a bulk loader utility from Oracle
for loading data into Oracle tables where as DataStage OCI
(Oracle Call Inteface) is a passive stage that connects to
any Oracle Database and collects necessary data and passes
it on to Datastage ETL for processing and applying
transformation where necessary and loads into target table.
DataStage OCI offers input and output stages for
conveniently connecting to Oracle Source databases and
Target Oracle databases.
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
What are constraints and derivations?
What is a merge?
Can anyone tell me a difficult situation who have handled while creating Datastage jobs?
How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...
root tree will find which is server job and which is parallel job?
Explain how a source file is populated?
What are the steps required to kill the job in Datastage?
Define project in datastage?
How to perform incremental load in datastage?
how do u catch bad rows from OCI stage? And what CLI stands for?
Why we use surrogate key?
1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)
What are routines in datastage? Enlist various types of routines.
Name the command line functions to import and export the DS jobs?
Nls stands for what in datastage?
