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 5742

which dim, fact tables used in bank domain

HSBC, IBM,

1 7835

which unix commands mostly used in datastage

HSBC,

3 8787

In one project how many shared containers are created?

NTT Data,

3 6420

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

NTT Data,

2151

whom do you report?

NTT Data,

1930

Is possible to create skid in dim,fact tables?

NTT Data,

2636

what is the use of skid in reporting?

NTT Data,

2381

client know skid info?

NTT Data,

2082

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

2505

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 3551

how to load meta data

IBM,

2 4413

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 9743

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 8292

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 8306

Post New Data Stage Questions

Un-Answered Questions { Data Stage }

What is the difference between datastage and informatica?

1118

How many types of sorting methods are available in datastage?

1073

In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?

1501

im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination

2173

Can you define merge?

1123

Which algorithm you used for your hashfile?

1182

What are the areas of application?

1151

What is a merge?

1169

How a source file is populated?

1066

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

1131

In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name

2479

What is size of a transaction and an array means in a datastage?

1314

Difference between server jobs & parallel jobs?

1077

What are the different common services in datastage?

1285

How do you import and export data into datastage?

1234

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