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 15481

how to create document in datastage?

Cap Gemini,

1 7115

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

Cap Gemini,

5 15684

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

Toyota,

1 10217

explain unit testing,systemtesting,integrated testing

CSC,

1 6924

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

3 8412

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

Virtusa,

5 15924

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 12954

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

2224

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

Wipro,

10 16612

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

5 10310

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 22124

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

Syntel,

2 12777

How to remove duplicates in transformer stage? in parallel mode

Syntel, TCS,

6 17446

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 15352

Post New Data Stage Questions

Un-Answered Questions { Data Stage }

What are the types of jobs we have in datastage?

1075

Describe the main features of datastage?

1076

Define APT_CONFIG in Datastage?

1080

Why do we use link partitioner and link collector in datastage?

1136

1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?

2024

What is job control?

1111

Can anyone tell me a difficult situation who have handled while creating Datastage jobs?

3250

describe the Steps to confiure a Qlogic switch

2383

How do you schedule or monitoring the job?

1210

What are the benefits of datastage?

1238

How many types of stage?

1177

What are the some differences between 7.x and 8.x version of datastage?

1255

Explain the importance of surrogate key in data warehousing?

1190

why do u need the IOS upgradation in a FC switch

2281

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

2151

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