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 are the reusable tasks in informatica ?

CTS, HP, IBM, TCS,

11 54641

HOW DO YOU PARFORM INCREMENTAL LAOD ?

SAIC,

7 16769

WHAT IS THE NAME OF THAT PORT IN DYNAMIC CACHE WHICH IS USED FOR INSERT , UPDATE OPRATION ?

Oracle,

4 13753

HOW DO YOU CONNECT TO REMOTE SERVER ?

Patni, TCS,

1 8613

WHAT IS UPDATE OVERRIDE . DIFFERENCE BETWEEN SQL OVERRIDE AND UPDATE OVERRIDE ?

Target,

7 34616

how can one connect two fact tables ? is it possible ? how?

ABC, Oracle, Patni,

8 37466

In a mapping i have three dimensions. If i want to pass a same surrogate key value to all the three dimensions by using one sequence generator is possible?If the mapping is containing single flow? And in the same case if the mapping is contaning 3 flows for the three dimensions then by using one sequence generator can we populate surrogate key (same value) to all the three dimensions?

IBM,

6 13800

HOW TO PUBLISH A REPORT?

3 8808

HOW TO DEBUGGING A REPORT?

1 9322

WHERE WE USED JAVA CONCEPTS IN ACTUATE?

1 5663

GENARALLY HOW MANY REPORTS ARE CREATE FOR EACH ONE ?PLZ EXPLAIN AFEW FOR AUTOMOBILE PROJECTS?

4 6739

GENARALLY HOW MANY UNIVERSES ARE CREATE FOR EACH PROJECTS?

4 7664

GENARALLY WHAT ARE THE PROBLEMS ARE FACING WHILE CREATING REPORTS?

1 7333

HOW DO YOU SCHEDULE THE REPORTS?

5 9218

HOW YOU WORKED WITH MULTIPLE DATA SOURCES?IF YES ?HOW DO YOU LINK THEM?

CitiGroup,

4 10326

Un-Answered Questions { Data Warehouse }

Synchroness 1.What are hash prompts? Ans: Tree prompts in which hierarchies can be seen,they can be said as hash prompts. 2.User wants to see 5 more coloums in the report.We have package and data base,how will u implement using it in report.? Ans: 3.What is automatic optimization?what is optimization?what are the properties you set for optimization in report studio? 4.what is command to display first 10 records from a table? IGATE 1.In FM if we change a fact symbol to attribute,will it effect the report? 2.If a report is slow in generating output. How do u perform tuning? How do u reduce joins in sql? Using left outer join is it going to improve the report performance? IBM 1.How do you configure ? 2.How do you drill through report from RS to Analysis studio?

4758

what is smart metrics in microstrategy?

1048

what are the components in the cognos connection page consists (eg: my folder, public folder,directions, schedule management tool etc.....)

2087

How can we improve performance of data stage jobs?

1031

Name the third party tools that can be used in datastage?

1093

What are the advantages and disadvantages of reporting directly against the database?

995

How can we load the time dimension?

1209

What is meant by metadata in context of a data warehouse?

974

What is the difference between power center & power mart?

994

Name some categories in sas 9? : sas-grid-administration

989

name the sub-tabs which are in advance tab of ti?

What is session task and command task?

1314

From where u get the logical query of your request?

787

What needs to be done when the database is shutdown?

1035

----------------Describe DWH Architecture?

2081

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