Interested to Buy Any Domain ? << Click Here >> for more details...
I have oracle enterpaise stage, oracle bulkloader stage,
ODBC stage and I want to load data in to target, which of
the above stages do I need to use and why?
- 3 Answers
- 12822 Views
- Virtusa, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / vijaya
Hi
Its all depends on the source data if the data is coming
through oracle datastage then go for oracle enterprise stage
if it a incremental load but if it is initial load then go
for oracle bulkloader stage.Oracle enterprise is faster as
compare to ODBC.oracle enterprise runs parallel where as
ODBC runs seq.
| Is This Answer Correct ? | 10 Yes | 1 No |
Answer / ravi kumar
oracle enterpaise stag is best becs we can use develope any
one.
| Is This Answer Correct ? | 3 Yes | 0 No |
What are the functionalities of link partitioner and link collector?
what is Audit table?Have u use audit table in ur project?
on how many columns we can perform aggregation in the Aggregator stage?
Emp login_timestamp Logout_timestamp A,2019-02-01 02:24:15,2019-02-01 04:59:42 B,2019-03-29 14:43:30,2019-03-29 20:22:00 ABC,2019-03-29 12:43:00,2019-03-29 23:22:59 In the above calculate the duration of hours spent in office for each emp in datastage.
Why do we use exception activity in Datastage?
There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this
in datastage interview qustion source target ------- ------- 12345 1 2 3 4 5
I have the following columns in the EMP table Empid,Empname,Sal,month(Sal),year(Sal) and DOB(let us say the dob is 15th-Jan-1981) Desing a job such that the output contains the following empname,year(sal),tot(sal) and current age i.e. whether 18yrs or so on
what is the use of surogate key in datastage
What is the difference between validate and compile?
why do we need a datawarehouse when we have databases to store data?
Nls stands for what in datastage?
Teradata 
