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 6581

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

L&T,

2 12959

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

Mind Tree,

2 5361

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,

8792

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 9729

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

IBM,

2 6531

where the log files or tables can store in DS?

IBM,

2 6638

where we use config file as parameter ?

IBM,

1 6101

job locking methods? How can we unlock the job?

IBM,

3 9560

Is there any possibility to generate alphanumeric surrogate key?

ABC, IBM,

3 11829

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

IBM,

2812

Post New Data Stage Questions

Un-Answered Questions { Data Stage }

Explain entity, attribute and relationship in datastage?

1101

Highlight the main features of datastage?

1160

What is the sortmerge collector?

1130

What is a ds designer?

1070

Have you used Unstructured data?

1319

What are some prerequisites for datastage?

1097

What are the types of hashed files in data stage

1108

On which interface you will be working as a developer?

1042

Define oconv () and iconv () functions in datastage?

1416

how to add a new records into source?

2000

1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)

2730

What are transforms and what is the differenece between routines and transforms?

1064

Describe link sort?

1011

Is it possible to query a hash file?

2012

Can you explain tagbatch restructure operator?

1177

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