Data Stage Interview Questions
Questions Answers Views Company eMail

What is audit table?

1 5259

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

L&T,

2 11538

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

Mind Tree,

2 4459

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 3634

what is use of SDR function?

CGI,

4701

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

IBM,

1827

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

IBM,

1439

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

IBM,

8154

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 8197

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

IBM,

2 5069

where the log files or tables can store in DS?

IBM,

2 5552

where we use config file as parameter ?

IBM,

1 4931

job locking methods? How can we unlock the job?

IBM,

3 8088

Is there any possibility to generate alphanumeric surrogate key?

ABC, IBM,

3 10315

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

IBM,

2173


Post New Data Stage Questions

Un-Answered Questions { Data Stage }

On which interface you will be working as a developer?

626


Explain entity, attribute and relationship in datastage?

623


Differentiate between operational datastage (ods) and data warehouse?

665


How do you generate sequence number in datastage?

617


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

1659






What are the various kinds of containers available in datastage?

555


What are the enhancements made in datastage 7.5 compare with 7.0?

704


I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this

541


Can you define merge?

658


What are the main features of datastage?

653


What all the types of jobs you developed?

660


How will you move hashed file from one location to another location?

1647


What a datastage macro?

622


Name the third party tools that can be used in datastage?

603


how do u catch bad rows from OCI stage? And what CLI stands for?

2275