What is the difference between SQl Loader and OCI in datastage?
- 2 Answers
- 13368 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 |
what are the devoleper roles in real time? plz tell i am new to datastage....
Tell me Wt main advantage of Stage varibles? Project level hints?
Can you explain engine tier in information server?
I have a source like file it have Number of records and i want to load without first and last records in target?Datastage?
What are some prerequisites for datastage?
Explain entity, attribute and relationship in datastage?
how to convert rows into columns
how to transfer file from one system to another system in unix? which cmd to be use?
What is exact difference between Parallel Jobs and server Jobs..
source has 2 fields like COMPANY LOCATION IBM HYD TCS BAN IBM CHE HCL HYD TCS CHE IBM BAN HCL BAN HCL CHE LIKE THIS....... AND I WILL GET THE OUTPUT LIKE THIS.... Company loc count TCS HYD 3 BAN CHE IBM HYD 3 BAN CHE HCL HYD 3 BAN CHE PLZ SEND ME ANSWER FOR THIS QUESTION..........
diff between changecapture & diffrence stage which situvation we can use the diffrence stage ?
How do you start developing a datastage project?
Teradata 
