Interview Questions And Answers Forum

Ibraheem

Webmaster

From: Capital

Registered: 2012-03-16

Posts: 23,140

Website

Warehouse DataStage Interview Questions And Answers

Data Warehouse :: Warehouse DataStage Job Interview Questions and Answers

Data Warehouse DataStage guideline for job interview preparation. Explore list of Data Warehouse DataStage frequently asked questions(FAQs) asked in number of Data Warehouse DataStage interviews. Post your comments as your suggestions, questions and answers on any Data Warehouse DataStage Interview Question or answer. Ask Data Warehouse DataStage Question, your question will be answered by our fellow friends.

1 ► How to kill the job in data stage?
2 ► What is iconv and oconv functions?
3 ► What is job control? how can it used explain with steps?
4 ► Explain What are the enhancements made in datastage 7.5 compare with 7.0?
5 ► Explain If data is partitioned in your job on key 1 and then you aggregate on key 2, what issues could arise?
6 ► Explain How to run the job in command prompt in unix?
7 ► Explain What is merge and how it can be done plz explain with simple example taking 2 tables?
8 ► Explain What is the difference between Symetrically parallel processing,Massively parallel processing?
9 ► What are the command line functions that import and export the DS jobs?
10 ► How to populate source files?
11 ► How to fix the error "OCI has fetched truncated data" in DataStage?
12 ► Explain What is the difference between LOOK UP File Stage and LookUP stage?
13 ► How to create Containers?
14 ► Explain What are Sequencers?
15 ► Explain What are other Performance tunings you have done in your last project to increase the performance of slowly running jobs?
16 ► Explain It is possible to run parallel jobs in server jobs?
17 ► Explain how to improve the job performance?
18 ► Explain the difference between drs and odbc stage?
19 ► Explain What happens out put of hash file is connected to transformer ..What error it through?
20 ► Explain Containers  Usage and Types?
21 ► Explain How is datastage 4.0 functionally different from the enterprise edition now?? what are the exact changes?
22 ► Explain What is the flow of loading data into fact & dimensional tables?
23 ► Explain How many jobs have you created in your last project?
24 ► How to pass parameters to job by using file?
25 ► What is DS Director used for - did u use it?
26 ► list out the versions of datastage Parallel , server editions and in which year they are realised?
27 ► What is DS Administrator used for - did u use it?
28 ► It is possible to access the same job two users at a time in datastage?
29 ► How good are you with your PL/SQL please explain?
30 ► How to eliminate duplicate rows?
31 ► What is differences between Oracle8i/9i?
32 ► What is a project? Specify its various components?
33 ► Explain Dimensional modelling is again sub divided into 2 types?
34 ► Explain How to handle the rejected rows in datastage?
35 ► Explain What is job control?how it is developed?explain with steps?
36 ► Explain What does a Config File in parallel extender consist of?
37 ► Explain How to implement type2 slowly changing dimenstion in datastage?