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 6867

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 7124

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 7772

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 5487

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

Cap Gemini, TCS,

4 11947

How to create a doccument in datastage?

Cap Gemini,

1 7663

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

Reliance,

2386

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

Reliance,

1 6623

How can we do null handling in sequential files

Reliance,

3 15381

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

Reliance,

2 6691

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

Syntel,

2227

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,

2167

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 33073

What is PX?

IBM,

2 7052

what is time dimension? and how to populate time demension

TCS,

2 11571

Post New Data Stage Questions

Un-Answered Questions { Data Stage }

What is difference between server jobs & parallel jobs?

987

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

1442

which r the connectors used in san?

2145

What is the difference between hashfile and sequential file?

1190

How do u convert the columns to rows in datastage?

1142

Why do we use link partitioner and link collector in datastage?

1078

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

1047

explain about citrix scheduling tool in datastage

2382

Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also

3132

How you can fix the truncated data error in datastage?

1677

Explain Quality stage?

1090

What a datastage macro?

1007

Nls stands for what in datastage?

1145

How do you schedule or monitoring the job?

1135

What are data elements?

1107

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