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

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

HCL,

8 12958

Explain the ChangeApply stage?

11 13679

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

HCL,

7 14086

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

HCL,

2 8584

HOW MANY LEVELS CAN BE USED IN DRILL THROUGH REPORTS

iFlex,

2 7357

Which service handles requests for cognos connection,query studio and event studio.

HCL,

3 6578

what are typees of dimensions

HCL,

5 9417

what is logs in cognos

HCL,

1 4298

1. What is the difference between in creating filters in designer and business objects? 2.How did u give a developed universe to your client? 3.If i want to grant access to a report to a group of users,how do i do?

2 7432

how do u test a pros sql(works or not) without executing it?

DELL, HSBC,

1 11199

What is Render Variable? where u can use?

3 14072

Actually we have 500 users when they run the report display the flage image related country user? How its possible?

2042

What is a business view? and what is the difference b/w business view and folder?in cognos report life cycle when it will be involved ?

1 2890

What project,model,parameter maps,namespace and database definitions....... what these are all contains? what are differences b/w them?

IBM,

2157

Why we should go for cognos? when there are so many other BI(Reporting) tolls in front of us?

IBM, Wipro,

4 10409

Un-Answered Questions { Data Warehouse }

What is the meaning of Caching in Teradata?

1151

What is the profile and package?

2309

Is the physical structure of the data set in the same orientation as the report? Do you need to reshape the data sets? What method should you use to reshape the data–DATA steps,PROC TRANSPOSE,output data set from a procedure?

2257

Identifying the bottlenecks in various components of Informatica and resolving them.

1946

Difference between SAS STATA & SPSS?

1140

what is the use of backward drilling in cognos 8?is it possible?whats the uws of it?

2079

What are the some differences between 7.x and 8.x version of datastage?

1270

What is real-time datawarehousing?

1040

What are the ways to import data into catalog?

1097

tell me two or three issues from client side and how to solve those issues?

2179

Helow, i have a problem with runing-total function when i use it for a calculate row (for example : i need to diplay a running-total of total units ?)

2456

Explain substr function?

1122

All ready we have alias tables for modifications why we are using views if anybody this answer plz reply me

2108

Cleared COG-112 with 100% score today. What next certification should i go for?

1851

How can you validate all mappings in the repository simultaneously?

1383

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