Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between SQl Loader and OCI in datastage?
- 2 Answers
- 14961 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 a routine is called in datastage job?
Where do you see different stages in the designer?
Can you define merge?
Nls stands for what in datastage?
disign the complex job in u r project?(they are aksing only complex job design and then data flow...)
How do you register plug-ins?
What are data elements?
Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance
What are system variables and sequencers in datastage
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
Define meta stage?
Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2
Explain datastage architecture?
What are the job parameters?
How do you start developing a datastage project?
