1. Categories >> Software >> Data Warehouse >> Data Stage
  2. Suggest New Category
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 13403

how to create document in datastage?

Cap Gemini,

1 6166

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

Cap Gemini,

5 13552

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

Toyota,

1 9466

explain unit testing,systemtesting,integrated testing

CSC,

1 6217

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

 3 7214

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

Virtusa,

5 14043

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 11693

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

 1736

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

Wipro,

10 13581

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

 5 8337

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 20869

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

Syntel,

2 11547

How to remove duplicates in transformer stage? in parallel mode

Syntel, TCS,

6 15196

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 13491

Post New Data Stage Questions

Un-Answered Questions { Data Stage }

What is quality stage?

560

Name the different types of Lookups in Datastage?

718

what is the use of skid in reporting?

1945

EXPLAIN SCD

949

CHANGE CAPTURE

879




How a server job can be converted to a parallel job?

613

What are the stages in datastage?

628

tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise

2694

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

What is the difference between orabulk and bcp stages?

562

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

1437

how to implement scd2 in datastage 7.5 with lookup stage

5117

Define APT_CONFIG in Datastage?

655

How rejected rows are managed in datastage?

909

Is it possible to query a hash file?

1552

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