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 5733

which dim, fact tables used in bank domain

HSBC, IBM,

1 7821

which unix commands mostly used in datastage

HSBC,

3 8772

In one project how many shared containers are created?

NTT Data,

3 6407

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

NTT Data,

2149

whom do you report?

NTT Data,

1921

Is possible to create skid in dim,fact tables?

NTT Data,

2634

what is the use of skid in reporting?

NTT Data,

2379

client know skid info?

NTT Data,

2078

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

2501

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 3543

how to load meta data

IBM,

2 4400

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 9733

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 8288

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 8287

Post New Data Stage Questions

Un-Answered Questions { Data Stage }

Describe the main features of datastage?

1072

Where do the datastage jobs get stored?

1210

Why we use surrogate key?

1227

Can you explain how could anyone drop the index before loading the data in target in datastage?

1502

What is the project in datastage?

1106

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

2149

What is staging variable?

1084

What are the types of containers and how to create them?

974

What are stage variables and constants?

1145

sed,awk,head

1459

Demonstrate experience in maintaining quality process standards?

2543

Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2

777

Difference between data warehousing and olap?

1089

What are the enhancements made in datastage 7.5 compare with 7.0?

1146

Which warehouse using in your datawarehouse

2182

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