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 6886

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 7146

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 7798

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 5503

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

Cap Gemini, TCS,

4 11989

How to create a doccument in datastage?

Cap Gemini,

1 7694

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

Reliance,

2401

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

Reliance,

1 6643

How can we do null handling in sequential files

Reliance,

3 15423

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

Reliance,

2 6713

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

Syntel,

2236

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,

2194

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 33148

What is PX?

IBM,

2 7069

what is time dimension? and how to populate time demension

TCS,

2 11596

Post New Data Stage Questions

Un-Answered Questions { Data Stage }

Demonstrate experience in maintaining quality process standards?

2476

What are the functionalities of link partitioner and link collector?

961

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

1017

What is difference between symmetric multiprocessing and massive parallel processing?

1098

Explain how a source file is populated?

1327

What is the project in datastage?

1063

Can you implement SCD2 using join, transformer and funnel stage?

1515

Have you used Unstructured data?

1276

How to manage date conversion in Datastage?

1082

AGGREGATOR default datatype

1404

Name the different sorting methods in datastage.

1003

Define Merge?

1269

Could anyone give brief explanation bout datastage admin

2320

What is ibm datastage flow designer?

1096

What is the difference between account and directory options ?

1127

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