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

Data Stage Interview Questions

Questions Answers Views Company eMail

while we using change capture stage we have to be take two table thats are 1.before table 2. after table . what is before table and after table please give me clear notation Thank You very much in advance

MGL,

2 7913

If seg file having 10 records ex:eid 1 2 " " 10 if oracle database having 100 records ex:eid 1 2 " " 100 how to delete matched records permenently from oracle database using datastage ?

Infotech,

5 10182

How to exclude first and last lines while reading data into a sequential file(having some 1000 records).I guess probably by using unix filter option but not sure which to use

IBM,

6 30961

How to delete the data in dataset?types of deleting the data in dataset?

HSBC,

4 24831

we run a job in 4 nodes,i want to run same job on 8 nodes is it possible? job recompling is mandtory?why?

HSBC, NTT Data,

1 16927

tab1 tab2 1,a 1,d 2,b 3,c perfoms outerjoin what is the o/p? write sql query for outerjoin?

Infotech,

3 8870

i/p 1,a,1000 2,b,2000 3,c,3000 i want to get o/p as o/p 1,a,3000 2,b,4000 3,c,5000 how it can be done on using datastage?

HSBC,

5 12649

Hi All, I have a file. i need to fetch the records between first and last records by using transform stage. EX:- Source: EMPNO EMPNAME 4567 shree 6999 Ram 3265 Venkat 2655 Abhi 3665 Vamsi 5852 Amit 3256 Sagar 3265 Vishnu Target: EMPNO EMPNAME 6999 Ram 3265 Venkat 2655 Abhi 3665 Vamsi 5852 Amit 3256 Sagar I dont wan't to Shree and vishnu records.we can fetch another way also but How can I write the function in transform stage?

TCS,

2 7349

1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do

IBM,

2085

Hi friends If anybody completed datastage 8.5 certification.Could please guide me what are the topics new in 8.5 certification.

2 13866

Hi any one has datasatge 8.5 certication dump could you please provide your details i will contact you. send reply to my mail rajaadivi@gmail.com Thanks in Advance

2 3991

how to write server Routine coding?

Eric,

2127

What are the prerequisites for join stage

2 9503

What is the use of surrogate key stage?

2 6626

Can we use target hash file as a lookup ?

3327

Post New Data Stage Questions

Un-Answered Questions { Data Stage }

Whats difference betweeen operational data stage (ods) and data warehouse?

1116

What is the differentiate between data file and descriptor file?

1362

What are some different alternative commands associated with "dsjob"?

1169

Explain the situation where you have applied SCD in your project?

2040

What are the processing stages?

1100

Why do you need stage variables?

1180

What are the important features of datastage?

1127

Why do we use exception activity in Datastage?

1314

Explain connectivity between datastage with datasources?

976

what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?

1390

What are the types of views in datastage director?

1772

Differentiate between operational datastage (ods) and data warehouse?

1178

How do you import and export data into datastage?

1234

How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?

2615

What are routines in datastage? Enlist various types of routines.

1101

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