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 happens if the owner of an object does not exist in the destination project?

918

Can microstrategy desktop access operational data systems?

1070

What are attribute roles?

975

Does microstrategy web support clustering via cisco local router or any other third-party clustering software?

984

Can I access intelligent cubes without olap services?

1046

Can intelligence server integrate with my existing data structure?

1061

How do you ensure simultaneous releases across multiple operating systems?

970

Can reports be executed in off-peak periods?

997

Can microstrategy desktop access sap data?

948

How is the number of passes in a sql query significant in performance evaluation?

968

Why is it required to maintain a parent-child relationship among the various attributes? What are the various types of relationships depending on the number of participants?

1012

Is microstrategy desktop available in other languages?

1010

what is the difference between microstrategy and cognos?

928

what specific features and functionality do you get with olap services?

966

What are consolidations?

908

Un-Answered Questions { Data Warehouse }

Explain how to export mappings to the production environment?

977

Explain difference between snow flake and star schema.

1047

how you can enable bulk load mode in ti?

What is mapplet in informatica?

1057

Explain what are the various reporting tools in the market?

982

Can you explain the advantage of using shortcuts?

1029

Can you define cube?

1031

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

2064

Can any one say me how i can integrate 3 or more analytics like radio bottons,line chart,pie chart while designing a dash board in xcelsius and i am also facing problem to show one after another values in the same chat at a time..... Please help me out for this....

1955

How many types of transformations supported by sorted input?

1222

How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?

1975

how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara

807

I am unable to connect sever database(oracle) from gde(db config file) local system.i set all these?

1157

What would be the next step after collecting the data?

1191

What is powercenter on grid?

1179

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