Data Stage Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Data Stage Interview Questions

Questions Answers Views Company eMail

if we take 2 tables(like emp and dept), we use join stage and how to improve the performance?

Cap Gemini,

5 15458

how to create document in datastage?

Cap Gemini,

1 7106

how to transfer file from one system to another system in unix? which cmd to be use?

Cap Gemini,

5 15662

when u face critical situation in ur project, how to solve them?

Toyota,

1 10213

explain unit testing,systemtesting,integrated testing

CSC,

1 6916

how many stages are there in Datastage... Please clarify mee??

3 8393

what is the best stage in datastage parller jobs to use full out join and why

Virtusa,

5 15913

I have oracle enterpaise stage, oracle bulkloader stage, ODBC stage and I want to load data in to target, which of the above stages do I need to use and why?

Virtusa,

3 12946

Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance

2222

in sequtial file 2 columns avaliable,iwant only one column load the target how do it.

Wipro,

10 16584

insequential file 2header avaliable,and 100 records avaliable.how to skip the 2 headers and load 100 records target?

5 10291

I have scenario like this seq file --> transformer --> sort stage --> dataset In this job which prtitioning technique you are using and why???

CTS, IBM,

3 22114

how can we create a Sorrogate key in transformer stage? I want it in parallel mode

Syntel,

2 12769

How to remove duplicates in transformer stage? in parallel mode

Syntel, TCS,

6 17434

1.How to read multiple file from sequential stage. 2.If a file doesn't arrive or doesn't exists in sequential stage how do u handle this. 3.What do you do before taking data from source to staging area. 4. I have a remove duplicate stage and transformer stage.what will u do for optimizeing the performance of the job.

Syntel,

4 15334

Post New Data Stage Questions

Un-Answered Questions { Data Stage }

Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how

1542

Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...

4188

How can we improve the performance in datastage?

1099

What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)

2380

im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination

2166

What are the types of hashed files in data stage

1106

what is the use of surogate key in datastage

2307

What a datastage macro?

1055

What is a merge?

1158

What is the command line function to import and export the ds jobs?

1145

How to reverse the string using SQL?

1519

What is use Array size in datastage

1775

what is use of SDR function?

5169

What are the important features of datastage?

1119

why do u need the IOS upgradation in a FC switch

2279

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