Warehouse DataStage Interview Preparation Guide

Download PDF

by killing the respective processing i.d
first u have to go for manager click on job from menu bar then click on clean up resources there u will find pid with that go to administrator click on command type ds.tools there u can give the pid to kill the job

Iconv( )-----converts string to internal storage formatOconv( )----converts an expression to an output format

JCL defines Job Control Language it is ued to run more number of jobs at a time with or without using loops. steps:click on edit in the menu bar and select 'job properties' and enter the parameters asparamete prompt typeSTEP_ID STEP_ID stringSource SRC stringDSN DSN stringUsername unm stringPassword pwd stringafter editing the above steps then set JCL button and select the jobs from the listbox and run the job

Job control can be acquired using job sequence in datastage 8.0.1.with or without loops.from the menu select new->sequence job and get the corresponding stages in the palette.

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,

Data will partitioned on both the keys ! hardly it will take more for execution .

Using dsjob command,

-options

dsjob -run -jobstatus projectname jobname


Dsjob-run-jobstatus-PARAM<Parameter 1>=value PARAM<Paramer 2>value.
<project name><jobname>. . If jobstatus=0 successful run,status=1and2 warnigs but success otherwise abort.

Merge is used to join two tables.It takes the Key columns sort them in Ascending or descending order.Let us consider two table i.e Emp,Dept.If we want to join these two tables we are having DeptNo as a common Key so we can give that column name as key and sort Deptno in ascending order and can join those two tables

Symmetric Multiprocessing (SMP) - Some Hardware resources may be shared by processor. Processor communicate via shared memory and have single operating system.

Cluster or Massively Parallel Processing (MPP) - Known as shared nothing in which each processor have exclusive access to hardware resources. CLuster systems can be physically dispoersed.The processor have their own operatins system and communicate via high speed network

A. dsimport.exe- imports the DataStage components.
B. dsexport.exe- exports the DataStage components.

There are many ways to populate one is writting SQL statment in oracle is one way