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

Which are the olap tools available that are supported by oracle?

1 1001

What is the difference between olap and datawarehosue?

1 1030

Explain what are the different types of join operations?

1 1046

Explain the different types of data warehousing?

1 1055

Explain what are non-additive facts in detail?

1 1107

What is is a star schema?

1 1304

Explain what is a view as it relates to system modeling?

1 1054

Explain what are slowly changing dimensions?

1 1100

I know of using applysimple, but there are other ways too?

1 1019

Explain what are the various methods of getting incremental records or delta records from the source systems?

1 1044

Why denormalization is promoted in universe designing?

1 1058

Explain what are the various transformation available?

1 1100

How to reduce warnings?

1 1001

What is the difference between a primary and secondary actor in use case modeling?

1 1155

Explain what is partitioning? What are the types of partitioning?

1 1032

Un-Answered Questions { Data Warehouse }

EXL informatica Questions

1461

Does anybody have the sample of delivery document of cognos, or provide some link of websites Thanks

2095

Write the unconnected lookup syntax and how to return more than one column.

1174

1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)

2794

can any one help me now i am learning AB Inito but i don't have material and pdf's can any one provide pdf's to this mail id mohanraju0113@gmail.com thanks in advance...................................

2334

what are the dimensions that you have in your current project?list them?

2095

What is dimensional table?

1165

Hi, Does anybody has lastest SAS certification(base, adv., clinical)dumps,if anybody has please email me at mailtorajani76@gmail.com. Thanks

2313

sas implementing companies in pune implementing clinical projects if anyone knows plz send ans immediately

3663

Explain what is aggregate table and aggregate fact table ... Any examples of both?

1178

what are the names of the reports that you prepared?

1196

What sort of existing documents should business analysts refer to when starting on a new project?

1078

hi, this is harish. i had finsihed cognos course recently.can some one help in the area of project explination, interview questions,real time scenarious....this is my maild id nanagupta907@gmail.com

1998

Hi Friends, Am Priya,new to your forum. am looking for Interview questions on SAS Platform Administration. I searched everywhere but I couldn't find them,please can anyone help me with complete interview questions normally everyone will face in the interviews on SAS Administration. am really facing problems in the interviews,am not able to answer any of their questions. I would really appreciate all your help if you can email the complete Interview Questions to priyafeb84@gmail.com Kindly awaiting for your reply with eager

2152

What are the data types present in bo? What happens if we implement view in the designer and report?

1082

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