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 13230

Explain the ChangeApply stage?

11 14089

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

HCL,

7 14309

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

HCL,

2 8664

HOW MANY LEVELS CAN BE USED IN DRILL THROUGH REPORTS

iFlex,

2 7472

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

HCL,

3 6701

what are typees of dimensions

HCL,

5 9583

what is logs in cognos

HCL,

1 4371

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 7488

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

DELL, HSBC,

1 11271

What is Render Variable? where u can use?

3 14205

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

2084

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 2963

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

IBM,

2200

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

IBM, Wipro,

4 10597

Un-Answered Questions { Data Warehouse }

For faster process, what we will do with the universe?

1040

What is Redshift Enhanced VPC Routing?

Describe the differences between a data warehouse and data mart.

1071

Can you explain the process of calendar?

1167

What is real-time datawarehousing?

1082

What are the batches and it’s details?

1031

Explain the tuning lookup transformation - informatica

1057

Why facts table is useful in representing the data?

1057

What is the difference between INPUT and INFILE ?

1397

Where the applications and where ware house management system is used?

1062

What is data stream and data adapter is it same are different?

1031

What is informatica worklet?

1123

what is the difference between cubes and package in cognos

5005

How do you control the number of observations and/or variables read or written?

1311

Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.

2335

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