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

Data Stage Interview Questions

Questions Answers Views Company eMail

can explain wt is the pool for file.

CTS,

1 6970

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?

IBM,

1 7212

if a column contains data like ram,rakesh,madhan,suraj,pradeep,bhaskar then I want to place names separated by commas in another columns how can we do?

IBM,

2 7926

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?

IBM,

1 5577

How to transfer file from one system to another system in UNIX?which command to be use?

Cap Gemini, TCS,

4 12237

How to create a doccument in datastage?

Cap Gemini,

1 7793

How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?

Reliance,

2452

What is the function in Transformer stage can act as Rank Function in oracle

Reliance,

1 6714

How can we do null handling in sequential files

Reliance,

3 15562

on how many columns we can perform aggregation in the aggregator stage?

Reliance,

2 6810

Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.

Syntel,

2295

Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?

HCL,

2238

A flatfile contains 200 records.I want to load first 50 records at first time running the job,second 50 records at second time running and so on,how u can develop the job?pls give the steps?pls pls

TCS,

7 33448

What is PX?

IBM,

2 7156

what is time dimension? and how to populate time demension

TCS,

2 11705

Post New Data Stage Questions

Un-Answered Questions { Data Stage }

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)

924

How many types of sorting methods are available in datastage?

1076

Distinguish between informatica & datastage. Which one would you choose and why?

1010

Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how

1555

What is a datastage job?

1015

Define Job control?

1153

What are the steps needed to create a simple basic datastage job?

1242

What is the difference between an operational datastage and a data warehouse?

1157

EXPLAIN SCD

1413

how to delete one row in target dataset

3125

for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr

1384

What are the main features of datastage?

1285

Define meta stage?

1207

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

1103

What is the difference between Datastage 7.5 and 7.0?

1098

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