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 6991

what is a query subjects item?

HCL,

1 4291

difference between drill through and master detail report?

HCL, Zensar,

2 24827

write a query to display the departments with no employee?

HCL,

2027

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

HCL,

2 5757

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

HCL,

4 8501

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

HCL, Syntel,

1 17964

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

HCL,

6 9545

what is an sid (surrogate key)?

IBM,

4 10687

What is the difference between filter & Condition?

MetLife, TCS,

3 10394

What is the difference between macro & Parameter

IBM,

1 3416

What is Complex Reports?

TCS,

3 15883

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??

2160

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

IBM,

3 6894

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

IBM,

2085

Un-Answered Questions { Data Warehouse }

Can anyone explain me a scenario from banking and finance...more precisely a mapping

2561

How to generate a report by getting values from two reports. The generated report should contain the 5 values of first report and last 5 values of second report?

1040

What is clusterservices in obiee ? Why its used?

999

How to create Target definition for flat files?

1291

explain what is factor analysis? : Sas-administrator

1180

Explain what type of indexing mechanism do we need to use for a typical datawarehouse?

1079

How to create a cube in Transformer? What is the process? Please mention process thank u

1817

What is report template in b.o?

1085

differentiate between two-tier, three-tier and four-tier connections.

1047

explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?

2205

what are the devoleper roles in real time? plz tell i am new to datastage....

2221

Demonstrate experience in maintaining quality process standards?

2657

define feeders?

What are the different types of transformation available in informatica.

1149

Explain how merging helps to combine data sets.

1124

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