Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between SQl Loader and OCI in datastage?
- 2 Answers
- 14822 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
how many rows sorted in sort stage by default in server jobs
What is a merge?
How a server job can be converted to a parallel job?
Can you explain players in datastage?
What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?
Explain ibm infosphere information server and highlight its main features?
What are the primary usages of datastage tool?
Can you filter data in hashed file?
What are the types of containers and how to create them?
What is the process of killing a job in datastage?
DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks
table actions available in oracle connector?
How many Key we can define in remove duplicate stage?
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
Describe the architecture of datastage?
