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 are the partitioning techniques available in link partitioner?

2279

What is the purpose of interprocessor stage in server jobs?

ASD Lab,

2233

Can you filter data in hashed file?

3772

How many Nodes configuration file you used in your last project?

1 4259

Tell me the syntax of Configuration file?

1 5001

Explain the situation where you have applied SCD in your project?

2040

What are the third party tools you used in your project?

IBM,

1 3281

How do you design PX Routines ?

1 3397

What is the use of Row generator stage?

2 13279

How you Implemented SCD Type 1 & Type 2 in your project?

4129

On which Dimension Table you implemented SCD Type in your Project

2044

How you Remove the Dataset in Unix?

5 21647

What is the difference b/w Hash file and Lookup Fileset stages?

1 10914

What is the default padding character?

IBM,

3 15639

What are the partition techniques available in your last project?

1 5317

Post New Data Stage Questions

Un-Answered Questions { Data Stage }

Define orabulk and bcp stages?

1122

What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?

2968

Highlight the main features of datastage?

1160

Which warehouse using in your datawarehouse

2185

What is the differentiate between data file and descriptor file?

1362

What are the steps required to kill the job in Datastage?

1218

what is the use of skid in reporting?

2381

why do u need the IOS upgradation in a FC switch

2281

What is apt_config in datastage?

1139

What is the use of hoursfromtime() function in transformer stage in datastage?

1068

Why we use surrogate key?

1235

How do u convert the columns to rows in datastage?

1194

DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks

1538

options available in sequence job to run,validate?

1316

1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?

2277

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