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 6436

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 5053

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

TCS,

3 14339

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 9081

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

TCS,

6 12555

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 13834

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 14220

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

TIAA CREF,

3 17550

How to find value from a column in a dataset?

TIAA CREF,

2250

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

TIAA CREF,

2 7881

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 7683

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 7581

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 7033

Post New Data Stage Questions

Un-Answered Questions { Data Stage }

What is the difference between in process and inter process?

1203

What are the types of views in datastage director?

1826

how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.

3403

Can you explain repository tables in datastage?

1455

How do you run datastage job from the command line?

1129

why do u need the IOS upgradation in a FC switch

2337

Name the different types of Lookups in Datastage?

1313

State the difference between an operational datastage and a data warehouse?

1183

What are the enhancements made in datastage 7.5 compare with 7.0?

1208

Difference between server jobs & parallel jobs?

1131

What is the sortmerge collector?

1176

What are the different kinds of views available in a datastage director?

1075

What is ibm datastage flow designer?

1204

Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.

2115

What all the types of jobs you developed?

1248

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