Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between SQl Loader and OCI in datastage?
- 2 Answers
- 14829 Views
- CSC, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / roshan nayak
An addition of above info through sqlldr we load bulk data
for this we use ora bulk stage. In this we load data
through script so data loaded in form of package. But there
is some restriction also, when we load data (bulk) target
table should not have index. We generally load data in
table-partation like weekly,monthly. It is faster than OCI.
Where as through OCI we load data as sequence manar. we can
set buffer size as require to read or write data. Here no
need to remove index from table.
| Is This Answer Correct ? | 4 Yes | 1 No |
Differentiate between datastage and informatica?
how to sort two columns in single job in datastage.
How u implement the slowly changing dimensions if my source table is consisting of cid,cname,add,phno,email but i need to capture the changes for first three columns how u implement?
hi i am bhavani, in real time data stage who is the source provide? and how to recevied in developer? Pls send me answer
What is configuration your file structure 2)I have two databases both are Oracle while loading data from source to target the job takes 30 min but I want to load less time how?
How to remove blank spaces from data?
Whats difference betweeen operational data stage (ods) and data warehouse?
How can i approach to write datastage 7.5 Certification? and how much they will charge for examination .What exactly should i do? Can anyone guide me plz?
What is the difference between in process and inter process?
In aggregator stage,to find the sum of the entire group of columns,it displays in binary format. How can i solve this problem.
How many Nodes configuration file you used in your last project?
How to Convert the columns into rows?
Teradata 
