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 audit table?

1 6584

How to enter a log in auditing table whenever a job get finished?

L&T,

2 12960

1.When did 8.1 parallel came into existence? 2.What is the difference between 7.5 and 8.1?

Mind Tree,

2 5362

Instead of using shared container in a job, I use jobs which perform similar function as Container in the sequence. Then what is the need of Shared Container?

TCS,

1 4628

what is use of SDR function?

CGI,

5173

what is the use of DSattchJob?DetachJob? where can we find it?

IBM,

2271

root tree will find which is server job and which is parallel job?

IBM,

1967

how can we create rank using datastage?what is the meaning of rank?

IBM,

8794

how do u convert date in 20-12-07 to dec-20-2007 or 20-dec- 2007 or 20-dec-07 in parallel

Wipro,

3 9730

is it possible to access the same job by two users at a time in DataStage?

IBM,

2 6532

where the log files or tables can store in DS?

IBM,

2 6640

where we use config file as parameter ?

IBM,

1 6104

job locking methods? How can we unlock the job?

IBM,

3 9563

Is there any possibility to generate alphanumeric surrogate key?

ABC, IBM,

3 11832

what are .ctl(control files) files ? how the dataset stage have better performance by this files?

IBM,

2813

Post New Data Stage Questions

Un-Answered Questions { Data Stage }

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

Why do you need stage variables?

1180

How to Remove Duplicate using SQL?

1370

root tree will find which is server job and which is parallel job?

1967

what is the use of skid in reporting?

2381

What is the project in datastage?

1114

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

2294

What are the different kinds of views available in a datastage director?

1030

how to run a sequential file stage in parallel if the stage is used on the TARGET side

1746

How do you import and export data into datastage?

1234

Differentiate between Join, Merge and Lookup stage?

1093

what is the use of surogate key in datastage

2310

What is the difference between validated and compiled in the datastage?

1293

What all are the different way to run a job?

1094

What is datastage engine?

1179

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