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

Teradata (490)
Business Objects (875)
Cognos (1143)
Informatica (2428)

SAS (1049)
Micro Strategy (282)
ETL (315)
OBIEE (92)

Data Warehouse Interview Questions

Questions Answers Views Company eMail

wat is sas? is a package or programming language?

4 10582

code the tables statement for a single level frequency?

2 6354

how do we get duplicate observations in a separate dataset?

CitiGroup,

6 14585

what is the difference between compiler and interpreter? give any one example (software product) that act as a interpreter?

Accenture, College School Exams Tests, CTS, IBM, IHRD, Infosys, Sylhet Engineering College, TCS, Wipro,

36 149532

what is the difference between %put and symbolgen?

6 24588

where will go the observations that were deleted by delete statement?

2 6201

WHAT SHOULD BE DONE WHEN A REPORT RUNNING TIME WILL TAKE LONG TIME IN CONGNOS?

ABC Infotech, Virtusa,

2 10654

WHAT STEPS SHOULD BE TAKEN BY A REPORT DEVELOPER TO INTERACT WITH THE CLIENT SERVER?

1 3966

how u provide security to reports??how u provide security to packages ?

Wipro,

5 11982

how u burst the reports? if u r bursted reports is not reached to destination how u identify???

Infosys, Wipro,

2 11776

how u migrate the reports from impromptu to reportnet???

Wipro,

3 9669

can reportnet supports cubes???

IBM, Wipro,

4 9276

what is meta data? Explain? Where it is used?

9 12668

What is lookup table?

5 25464

What is mapping?

3 8417

Un-Answered Questions { Data Warehouse }

How can we use external procedural logic in informatica?

934

What is grain of fact?

995

What is set to be Cognos configuration?

1046

What is cfapplication tag?

976

what is the cube size?

Define Job control?

1161

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

1428

List down some of the real time data-warehousing tools?

994

difference between paramaters inputparameters,Local parameters, Formal parameters, Sand box parameters,Project parameters and export parameter?

2847

What is the good sas programming practices for processing large data sets?

1136

What is the purpose of having stored procedures in a database?

1183

How do dates work in SAS data?

1192

what will be the contents for a functional requirements specifications

2368

What is source qualifier transformation in informatica?

1026

How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?

1986

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