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 the filename which you need to configure in UNIX while installing infromatica?

2 15085

If you have 10 mappings designed and you need to implement some chages (may be in existing mapping or new mapping need to be designed) then how much time it takes from easier to complex?

1 5689

In Microstrategy, how can you direct the sql generated to use a specifc table?

Lanco,

7 22559

What is pragma?

1 5824

What are steps to be taken care to create a good Universe?

2 7980

Explain the SQL Queries activated to data base from Data provider in BO ?

Polaris,

1 4773

What is the test methodology for testing BO Universes?

Cisco, TCS,

3 10938

How to create Universe using Flat file in BO6.0

1 6785

What is the drill up , drill down, drill by , drill trough ?

TCS,

3 21684

What's the Functional & Architectural Differences between Business Objects & Web Intelligence Reports?

HCL,

2209

How toconnect one to one report?

iFlex,

4 10113

What are the steps to taken care to improve the Report performance?

3 9437

What is the local filter and global filter in bo's?

8 17770

Explain in Detail about Measure Objects? and what is the use of it? How to create it?

5 10611

How can we acheive Correlated sub-query in Designer?

Infosys, TCCX, Wells Fargo,

2 16079

Un-Answered Questions { Data Warehouse }

How do we call shell scripts from informatica?

1197

This entry was posted in General. Bookmark the permalink. Post a comment or leave

4635

What is a real-time data warehouse?

1045

What do the sas log messages “numeric values have been converted to character” mean? What are the implications?

1259

What is is the guidelines to build universe with better performance? R performance tuning issues of universes?

964

Discuss the advantages of using partitioned primary index in a query?

1009

Explain as a ba (business analyst) approaching a new piece of work, who would you interview and what questions would you ask?

1102

what is the output when -1 is put in select_expr of FBE?

1456

how will you implement security in obiee,so that subjects areas accessed by one group are not accessed by another group.

920

What are the issues you have faced in your project? How did you overcome those issues?

2423

What are the key elements of a data processing system?

1322

What are the types of studio?

1206

If Fast Load Script fails and only the error tables are made available to you, then how will you restart?

1230

For which purpose Redshift is used for ?

What is a macro routine?

2804

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