Data Stage Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Data Stage Interview Questions

Questions Answers Views Company eMail

what is materialized view used datastage?

HSBC,

1 5750

which dim, fact tables used in bank domain

HSBC, IBM,

1 7837

which unix commands mostly used in datastage

HSBC,

3 8798

In one project how many shared containers are created?

NTT Data,

3 6432

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

NTT Data,

2156

whom do you report?

NTT Data,

1935

Is possible to create skid in dim,fact tables?

NTT Data,

2642

what is the use of skid in reporting?

NTT Data,

2381

client know skid info?

NTT Data,

2088

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

2508

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 3562

how to load meta data

IBM,

2 4427

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 9748

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 8299

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 8318

Post New Data Stage Questions

Un-Answered Questions { Data Stage }

EXPLAIN SCD

1413

State the difference between an operational datastage and a data warehouse?

1136

Why do we use exception activity in Datastage?

1321

What are stage variables?

1209

How rejected rows are managed in datastage?

1526

What are the benefits of datastage?

1238

What is process model?

1986

Differentiate between odbc and drs stage?

1057

options available in sequence job to run,validate?

1326

What is the difference between datastage and datastage tx?

1071

Describe the architecture of datastage?

1011

How one source columns or rows to be loaded in to two different tables?

1131

Describe routines in datastage? Enlist various types of routines.

1016

How many Key we can define in remove duplicate stage?

1391

what is ds administrator used for?

1175

For More Un-Answered { Data Stage } Questions Click Here