Data Stage Interview Questions
Questions Answers Views Company eMail

what is materialized view used datastage?

HSBC,

1 4850

which dim, fact tables used in bank domain

HSBC, IBM,

1 6483

which unix commands mostly used in datastage

HSBC,

3 7334

In one project how many shared containers are created?

NTT Data,

3 5122

How will you move hashed file from one location to another location?

NTT Data,

1629

whom do you report?

NTT Data,

1484

Is possible to create skid in dim,fact tables?

NTT Data,

2156

what is the use of skid in reporting?

NTT Data,

1928

client know skid info?

NTT Data,

1610

A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?

1998

hi i am bhavani, in real time data stage who is the source provide? and how to recevied in developer? Pls send me answer

Polaris,

1 2715

how to load meta data

IBM,

2 3408

This is UNIX question asked in DataStage Interview. Say I have n numbers of records in a text file. I want first 3 records in 1st file, last three records in 3rd file and remaining n-6 records in 2nd file. (Note: we don't know how many records are there in the File. I am getting one file on daily basis and I want three target files as asked above)

CTS,

2 8493

eno ename 1 qaz 1 wsx 1 edc 2 zxc 2 asd 3 qwe 3 wer 3 tru 4 rgj Output: eno ename count 1 qaz,wsx,edc 3 2 zxc,asd 2 3 qwe,wer,tru 3 4 rgj 1 I want the above output to be solved by DataStage as well and I have to write SQL query for the same output.

Wipro,

4 6685

Scenario : I have 2 jobs say job A and Job B with parameters x and y respectively. I need to create a sequence job. If we pass parameter x then Job A should run, If we pass parameter y then Job B should run, if we dont pass any parameter then Both Job A & B should run.

iGate, Thirdware,

4 6628


Post New Data Stage Questions

Un-Answered Questions { Data Stage }

What is meta stage?

555


What are the benefits of datastage?

690


What is the differentiate between data file and descriptor file?

829


file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4

515


How to find value from a column in a dataset?

1749






Differentiate between odbc and drs stage?

570


What is the process of killing a job in datastage?

567


Could anyone give brief explanation bout datastage admin

1940


how can we create rank using datastage?what is the meaning of rank?

8130


how many rows sorted in sort stage by default in server jobs

3532


What is aggtorec restructure operator?

699


Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...

3732


create a job that splits the data in the Jobs.txt file into four output files. You will direct the data to the different output files using constraints. • Job name: JobLevels • Source file: Jobs.txt • Target file 1: LowLevelJobs.txt − min_lvl between 0 and 25 inclusive. − Same column types and headings as Jobs.txt. − Include column names in the first line of the output file. − Job description column should be preceded by the string “Job Title:” and embedded within square brackets. For example, if the job description is “Designer”, the derived value is: “Job Title: [Designer]”. • Target file 2: MidLevelJobs.txt − min_lvl between 26 and 100 inclusive. − Same format and derivations as Target file 1. • Target file 3: HighLevelJobs.txt − min_lvl between 101 and 500 inclusive. − Same format and derivations as Target file 1. • Rejects file: JobRejects.txt − min_lvl is out of range, i.e., below 0 or above 500. − This file has only two columns: job_id and reject_desc. − reject_desc is a variable-length text field, maximum length 100. It should contain a string of the form: “Level out of range: ”, where is the value in the min_lvl field. My Question is how do you write the stage variable for reject rows.

2173


What are the types of containers in datastage?

682


What is a datastage job?

595