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

what is cardinality that you can give to employee and department query subjects in framework manager?

HCL,

2 6857

what is a query subjects item?

HCL,

1 4198

difference between drill through and master detail report?

HCL, Zensar,

2 24698

write a query to display the departments with no employee?

HCL,

1971

write a query to display to 10 max record from the employee table?

HCL,

2 5625

write a query to display the third record from the employee table?

HCL,

4 8307

what is prompt types of prompt example briefly each types of product (eg:values, date,search,prompt etc.)

HCL, Syntel,

1 17869

how can create a report like if the salary>50,000 display balance,if salary<50,000 display green?

HCL,

6 9241

what is an sid (surrogate key)?

IBM,

4 10498

What is the difference between filter & Condition?

MetLife, TCS,

3 10244

What is the difference between macro & Parameter

IBM,

1 3332

What is Complex Reports?

TCS,

3 15737

hi my question is in a report table how can we write table header without using of individual cell.can we merge column cells togrther??

2060

what is filter?give me one example that you created a report in your project?

IBM,

3 6759

what are the dimensions that you have in your current project?list them?

IBM,

2024

Un-Answered Questions { Data Warehouse }

What is meant by Reportstudio shortcut?

2188

How to provide security in frame work manager for a query subject?

961

Give the benefits of data integration suite?

921

What are the steps required to kill the job in Datastage?

1218

explain about your project architecture in ssis..could u please send to my mail..vinod.kjvk@gmail.com

4112

What is the use of Cognos scenario?

1194

What is the basic syntax of a sas program?

1207

what is hierarchy flattening? : Sas-di

1081

Enlist the tasks for which source qualifier transformation is used.

1040

Explain what is the difference between power center & power mart?

999

2. We have asked to create a repots showing sales by region in order to determine which regions are generating the most revenue and highest sales volume. The report needs to include the revenue and quantitiy sold of each subcategory with in category.

2212

How will you go about adding additional column to the repository in the presentation layer?

925

Is it possible to get a floating window in microstartegy web? If yes, how?

1158

What do you mean by caching in teradata?

1064

what is use of SDR function?

5173

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