|
INTERVIEW QUESTIONS
DATA WAREHOUSING
DATASTAGE
DETAILS
Question: What are the enhancements made in datastage 7.5 compare with 7.0
Answer: Many new stages were introduced compared to datastage version 7.0. In server jobs we have stored procedure stage, command stage and generate report option was there in file tab. In job sequence many stages like startloop activity, end loop activity,terminate loop activity and user variables activities were introduced. In parallel jobs surrogate key stage, stored procedure stage were introduced. For all other specifications,
|
|
|
Category |
DataStage Interview Questions & Answers -
Exam Mode /
Learning Mode
|
Rating |
(0.3) By 9152 users |
Added on |
7/26/2011 |
Views |
66877 |
Rate it! |
|
|
Question:
What are the enhancements made in datastage 7.5 compare with 7.0
Answer:
Many new stages were introduced compared to datastage version 7.0. In server jobs we have stored procedure stage, command stage and generate report option was there in file tab. In job sequence many stages like startloop activity, end loop activity,terminate loop activity and user variables activities were introduced. In parallel jobs surrogate key stage, stored procedure stage were introduced. For all other specifications, Source: CoolInterview.com
If you have the better answer, then send it to us. We will display your answer after the approval.
Rules to Post Answers in CoolInterview.com:-
- There should not be any Spelling Mistakes.
- There should not be any Gramatical Errors.
- Answers must not contain any bad words.
- Answers should not be the repeat of same answer, already approved.
- Answer should be complete in itself.
|
|
Related Questions |
View Answer |
|
If I add a new environment variable in Windows, how can I access it in DataStage?
|
View Answer
|
|
1.What about System variables? 2.How can we create Containers? 3.How can we improve the performance of DataStage? 4.what are the Job parameters? 5.what is the difference between routine and transform and function? 6.What are all the third party tools used in DataStage? 7.How can we implement Lookup in DataStage Server jobs? 8.How can we implement Slowly Changing Dimensions in DataStage?. 9.How can we join one Oracle source and Sequential file?. 10.What is iconv and oconv functions? 11.Difference between Hashfile and Sequential File? 12. Maximum how many characters we can give for a Job name in DataStage?
|
View Answer
|
|
It is possible to call one job in another job in server jobs?
|
View Answer
|
|
What is hashing algorithm and explain breafly how it works?
|
View Answer
|
|
If a DataStage job aborts after say 1000 records, how to continue the job from 1000th record after fixing the error?
|
View Answer
|
|
How to implement type2 slowly changing dimensions in data stage?explain with example?
|
View Answer
|
|
Is it possible to move the data from oracle ware house to SAP Warehouse using with DATASTAGE Tool.
|
View Answer
|
|
How much would be the size of the database in DataStage ? What is the difference between Inprocess and Interprocess ?
|
View Answer
|
|
How I can convert Server Jobs into Parallel Jobs?
|
View Answer
|
|
What is the max capacity of Hash file in DataStage?
|
View Answer
|
|
How to use rank&updatestratergy in datastage
|
View Answer
|
|
What is the difference between drs and odbc stage
|
View Answer
|
|
what is meaning of file extender in data stage server jobs. can we run the data stage job from one job to another job that file data where it is stored and what is the file extender in ds jobs.
|
View Answer
|
|
How does DataStage handle the user security?
|
View Answer
|
|
What are the Steps involved in development of a job in DataStage?
|
View Answer
|
|
Briefly describe the various client components?
|
View Answer
|
|
What is a project? Specify its various components?
|
View Answer
|
|
* What are constraints and derivation?
* Explain the process of taking backup in DataStage?
*What are the different types of lookups available in DataStage?
|
View Answer
|
|
Will the data stage consider the second constraint in the transformer once the first condition is satisfied ( if the link odering is given)
|
View Answer
|
|
How to remove duplicates in server job
|
View Answer
|