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 7795

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 9942

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 30718

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

HSBC,

4 24640

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 16818

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

Infotech,

3 8731

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 12437

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 7235

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,

2045

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

2 13730

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 3882

how to write server Routine coding?

Eric,

2063

What are the prerequisites for join stage

2 9369

What is the use of surrogate key stage?

2 6479

Can we use target hash file as a lookup ?

3264

Post New Data Stage Questions

Un-Answered Questions { Data Stage }

What is a datastage job?

965

Can you explain how could anyone drop the index before loading the data in target in datastage?

1442

What are the different kinds of views available in a datastage director?

973

Have you used Unstructured data?

1269

What is the sortmerge collector?

1083

What is the importance of the exception activity in datastage?

1018

What are the important features of datastage?

1050

Describe the main features of datastage?

1039

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

1047

if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?

2171

What is orabulk stage?

992

what is 'reconsideration error' and how can i respond to this error and how to debug this

2557

What is the difference between operational data stage (ods) and data warehouse?

1178

What is the purpose of interprocessor stage in server jobs?

2171

What could be a data source system?

941

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