Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

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 4272

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 4014

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

TCS,

1 3177

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

TCS,

3 10330

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 6185

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

TCS,

6 7965

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 9937

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,

8 8062

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

TIAA CREF,

3 12105

How to find value from a column in a dataset?

TIAA CREF,

1314

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

TIAA CREF,

2 5057

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 5400

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

TIAA CREF,

1 5461

what is operator combinality in datastage?

TCS,

1 5877

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 4817


Post New Data Stage Questions






Un-Answered Questions { Data Stage }

What is active and passive stage?

183


Where do the datastage jobs get stored?

139


What is the use of datastage director?

139


What is the process of killing a job in datastage?

122


A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?

1432






what is the use of materialized view?

464


What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)

1453


What is the differentiate between data file and descriptor file?

170


What are transforms and what is the differenece between routines and transforms?

160


What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?

1191


what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees

121


What is "fatal error/rdbms code 3996" error?

159


What are the benefits of datastage?

148


Define Data Stage?

177


Which commands are used to import and export the datastage jobs?

167