Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between SQl Loader and OCI in datastage?
- 2 Answers
- 14702 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 |
how can u handle null values in transformer stage.
What are some different alternative commands associated with "dsjob"?
col1 123 abc 234 def jkl 768 opq 567 789 but i want two targetss target1 contains only numeric values and target2 contains only alphabet values like trg1 123 234 768 567 789 trg2 abc def jkl opq
if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?
how do u catch bad rows from OCI stage? And what CLI stands for?
What is a quality stage?
I have a few records just I want to store each records tow times in target how?
what is diff b/w datastage 8.1,8.5,8.7?
how to find out number of records imported into source file?
i have a project manager round on sat this week can you post what are the main question i have to check.if you have any idea regular question on project pls send me. thanks in advance
What is APT_DUMP_SCORE?
How do you start developing a datastage project?
Teradata 
