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 12922

Explain the ChangeApply stage?

11 13617

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

HCL,

7 14045

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

HCL,

2 8568

HOW MANY LEVELS CAN BE USED IN DRILL THROUGH REPORTS

iFlex,

2 7337

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

HCL,

3 6563

what are typees of dimensions

HCL,

5 9387

what is logs in cognos

HCL,

1 4283

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 7407

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

DELL, HSBC,

1 11179

What is Render Variable? where u can use?

3 14057

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

2033

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 2875

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

IBM,

2147

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

IBM, Wipro,

4 10385

Un-Answered Questions { Data Warehouse }

can anybody tell me about complicated object you have created

3222

In abinitio, what types of parallelism are used?

1091

What are different types of metrics in microstrategy?

964

Suppose I want to get sales data for the last (suppose 10) dates dynamically using value prompt how can I do it and drag it onto report editor?

1060

What are the advantages of using sas?

1147

How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?

2182

What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?

1109

Explain are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?

1883

What are the different layers in the information server architecture?

1124

What is the difference between validated and compiled in the datastage?

1293

When we should use 'jobid' for commit table (Output table component?? How to use in abinitio graph?

2443

Informatica server and client are in different machines. You run the session from the server manager by specifying the source and target databases. It displays error . You are confident that everything is correct. Then why it is displaying the error?

3766

What is the basic syntax of a sas program?

1209

what are the basic features of cognos tm1?

Why cognos decision stream is used?

1160

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