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

Data Stage Interview Questions

Questions Answers Views Company eMail

What is confirmed Dimension? what is Factless Fact? give one example? What are Additive, Semi-Additive Facts?

TCS,

1 6439

diff between OLTP and OLAP? what TOP-DOWN and BOTTOM-UP Approach? which is best? what are Star Schema and Snow Flake Schema?

TCS,

2 7211

Display all files which have size more 3KB in given directory/folder.

TCS,

1 5056

I want capture UnMatched records from Primary source and secondary source in JOIN stage?

TCS,

3 14340

Unix Qn asked in datastage interview: I have diff type(.txt, .tmp, .bat etc) of file in 4 diff directories, I want move all '.txt' file from 4 directories to other folder. And need to delete all the files except which are created TODAY?

TCS,

2 9083

I have Seq file, I don't want 10, 11th(or any two records like 20, 30th records ) records in the output

TCS,

6 12559

I have load a Dataset in UAT with 2 Node configuration, imported the job into PROD environment which is 4 node configuration and using this DataSet as SRC to other job. will the job run fine or give any errors? If job runs fine, on how many nodes? 2 nodes or 4 nodes?

TCS,

2 13836

I have a input as: Col 1 1 2 2 3 I want 3 output as: Output1: 1 1 Output2: 2 2 Output3: 3 i.e. same duplicates should be in one target, other duplicate values should be in another target and so on.. Pls help

IBM,

9 14230

how can you generate sequence number using only the sequential file stage?

TIAA CREF,

3 17557

How to find value from a column in a dataset?

TIAA CREF,

2253

which is more expensive hash or modulus partitioning? when do you use modulus partitioning?

TIAA CREF,

2 7885

You enter values in a schema file for RCP and you also entered values in sequential file? which one will it take?

TIAA CREF,

1 7686

How do you load 10 different sources with 10 different layouts to 10 different tables?

TIAA CREF,

1 7423

what is operator combinality in datastage?

TCS,

1 7584

Hi guys, Design job sequence, we have 3 sources, in that 1st source in abort then only run the remaining sources.. How please design the job. Thanks.

IBM,

2 7038

Post New Data Stage Questions

Un-Answered Questions { Data Stage }

What is the difference between orabulk and bcp stages?

1076

What could be a data source system?

1098

What are the functionalities of link partitioner?

1068

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?

2288

Can we use target hash file as a lookup ?

3374

What is usage analysis in datastage?

1364

How and where you used hash file?

1226

Why we use surrogate key?

1306

i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS

3811

What is the differentiate between data file and descriptor file?

1412

Why fact table is in normal form?

1313

How do you schedule or monitoring the job?

1268

Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?

3853

Explain the datastage parallel extender (px) or enterprise edition (ee)?

1281

How to convert RGB Value to Hexadecimal values in datastage?

4060

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