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 6213

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 6925

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

TCS,

1 4874

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

TCS,

3 14054

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 8893

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

TCS,

6 11996

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 13547

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 13610

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

TIAA CREF,

3 17220

How to find value from a column in a dataset?

TIAA CREF,

2149

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

TIAA CREF,

2 7654

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 7459

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

TIAA CREF,

1 7282

what is operator combinality in datastage?

TCS,

1 7423

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 6800

Post New Data Stage Questions

Un-Answered Questions { Data Stage }

What are stage variables, derivations and constants?

1166

Define orabulk and bcp stages?

1069

What is merge stage?

1228

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

1047

What is the different type of jobs in datastage?

902

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

3701

DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks

1476

What are iconv and oconv?

1182

If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?

2003

what is the custome stage in datastage? how can we impliment that one? plz tell me

2317

How a source file is populated?

1020

Notification Activity

1350

Define Job control?

1062

What a datastage macro?

1007

What is the differentiate between data file and descriptor file?

1307

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