Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between SQl Loader and OCI in datastage?
- 2 Answers
- 14699 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
Differentiate between odbc and drs stage?
Where the datastage stored his repository?
How to clean the datastage repository?
What is the purpose of pivot stage and types of containers in datastage
im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination
Explain the importance of surrogate key in data warehousing?
What is "fatal error/rdbms code 3996" error?
Difference between server jobs & parallel jobs?
What are orabulk and bcp stages?
client know skid info?
disign the complex job in u r project?(they are aksing only complex job design and then data flow...)
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
What are the important features of datastage?
Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?
what are the errors,warnings in datastage
