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 6878

what is a query subjects item?

HCL,

1 4221

difference between drill through and master detail report?

HCL, Zensar,

2 24710

write a query to display the departments with no employee?

HCL,

1979

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

HCL,

2 5652

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

HCL,

4 8338

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

HCL, Syntel,

1 17886

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

HCL,

6 9284

what is an sid (surrogate key)?

IBM,

4 10520

What is the difference between filter & Condition?

MetLife, TCS,

3 10264

What is the difference between macro & Parameter

IBM,

1 3344

What is Complex Reports?

TCS,

3 15772

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

2079

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

IBM,

3 6782

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

IBM,

2037

Un-Answered Questions { Data Warehouse }

Differentiate between ceil and floor functions.

1173

What are the ways to do a “table lookup” in sas?

1044

Explain the purpose of substr functions in sas programming.

1075

What is the max core of a component?

1115

what is scheduling and how will u implement it. In scheduling 5 jobs r running if there is an error occured at 3rd job and how will u check and waht necessary steps will u take not to repeat the same mistake

2379

How would you write a simple stored procedure in tsql which takes a movie_id and returns all the directors associated with it?

1016

Explain security role?

956

What is the difference between dependent data warehouse and independent data warehouse?

1022

Explain the hierarchies level data warehousing.

900

in general which algorithms for used?

2037

What is depict expression change?

1134

what are the steps to troubleshoot the feeders?

What are the functionalities of link partitioner?

1035

explain about citrix scheduling tool in datastage

2468

Explain how spool space is used.

1087

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