Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

Data Stage Interview Questions
Questions Answers Views Company eMail

What is audit table?

1 4296

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

L&T,

2 9877

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

Mind Tree,

2 3588

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 2672

what is use of SDR function?

CGI,

4048

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

IBM,

1450

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

IBM,

1037

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

IBM,

7608

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 6116

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

IBM,

2 3987

where the log files or tables can store in DS?

IBM,

2 4386

where we use config file as parameter ?

IBM,

1 3986

job locking methods? How can we unlock the job?

IBM,

3 6317

Is there any possibility to generate alphanumeric surrogate key?

ABC, IBM,

3 8811

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

IBM,

1663


Post New Data Stage Questions






Un-Answered Questions { Data Stage }

If you want to use a same piece of code in different jobs, how will you achieve this?

178


How can we improve performance of data stage jobs?

189


What are the components of datastage?

177


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)

1935


what are the errors,warnings in datastage

1674






Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?

1324


i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS

2905


Highlight the main features of datastage?

201


Explain Quality stage?

192


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

1375


Differentiate between validated and Compiled in the Datastage?

191


What is a folder? Difference types of stages?

193


How to convert RGB Value to Hexadecimal values in datastage?

2961


What is the use of datastage director?

179


What are the types of containers in datastage?

213