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?

2247

What is the purpose of interprocessor stage in server jobs?

ASD Lab,

2190

Can you filter data in hashed file?

3738

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

1 4188

Tell me the syntax of Configuration file?

1 4903

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

1998

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

IBM,

1 3213

How do you design PX Routines ?

1 3310

What is the use of Row generator stage?

2 13176

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

4085

On which Dimension Table you implemented SCD Type in your Project

1976

How you Remove the Dataset in Unix?

5 21452

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

1 10794

What is the default padding character?

IBM,

3 15469

What are the partition techniques available in your last project?

1 5244

Post New Data Stage Questions

Un-Answered Questions { Data Stage }

Differentiate between validated and Compiled in the Datastage?

1217

what are the errors,warnings in datastage

2637

1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?

1973

How many areas for files does datastage have?

1096

How do you remove duplicate values in datastage?

1111

Explain usage analysis in datastage?

1115

Describe routines in datastage? Enlist various types of routines.

964

What is aggtorec restructure operator?

1371

How to convert RGB Value to Hexadecimal values in datastage?

3948

What are the features of datastage flow designer?

1006

Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.

2236

What is the difference between the local container and shared container?

1057

How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...

1463

Difference between ‘validated ok’ and ‘compiled’ in data stage?

1217

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

1080

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