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

Data Stage Interview Questions

Questions Answers Views Company eMail

how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)

920

Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2

779

Post New Data Stage Questions

Un-Answered Questions { Data Stage }

What are system variables and sequencers in datastage

1115

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

1094

What are iconv and oconv?

1243

What is the use of hoursfromtime() function in transformer stage in datastage?

1069

Different ways a project can be moved to production ?...example â€¦.export-import and Version control.

2446

What is a merge?

1169

What is the different type of jobs in datastage?

974

Describe the main features of datastage?

1076

what is the use of skid in reporting?

2381

Demonstrate experience in maintaining quality process standards?

2552

Enlist various types of routines in datastage.

1256

What are routines in datastage?

1329

How we can covert server job to a parallel job?

1147

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

2151

how many rows sorted in sort stage by default in server jobs

3997

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