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

1.Have u logical models in project? If s which logical model used? 2.how do u connect to production server? 3. how do u test the data in report is same as in DWH? 4. u created one report but there is no data in the attribute. But how can u extract the data from ware house? 5. u have two tables having different ids how do u merge those table in MSTR? 6. have u faced challenging situation in u r project? Give me one example?

2571

Input flatfile1 has 5 columns, faltfile2 has 3 columns(no common column) output should contain merged data(8 columns) Please let me know how to achieve ??

IBM,

3 7703

Can we have more than one time dimensions in a Schema(Star or Snowflake)

ASD Lab, IBM,

1 6402

how to merge 2 crosstabs thans

HCL,

2641

how to create calculate column in report studio

4 9172

what is the use of lock and unlock

1 5839

which type of project we r going to snowflake schema

IBM,

1978

can we create a chart without measure

3 7843

diff b/w dimension and regular dimension

1 5277

diff b/w layout calculation and query calculation

Cap Gemini,

2 7417

how to connect datamarts

HCL,

2794

diff b/w grouping and aggregation

HCL,

1 6158

how to improve performance in report studio level

Wipro,

1 6504

without using rank transformation how can we rank items by using some other transformations

2 15255

i have source data like id name sal 1 a 65020 2 b 78250 3 c 58264 but how to get target like this id name sal 1 a Sixty five thousand twenty 2 b Seventy thousand two fify 3 c Fifty eight thousand two sixty four

3 7205

Un-Answered Questions { Data Warehouse }

what is session partitioning?

2132

What is slibref?

1282

What is a logical size of a table and what does it depend on?

967

What is the diff between cognos 8.1 & cognos 8.2 & cognos 8.3? Measn whet are the enhancements are added in new versions(8.2& 8.3)?

4389

List out some key concept of SAS

1127

Explain the code page compatibility?

1071

What are the different table types that are supported by teradata?

1003

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)

2730

I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.

2066

what is microstrategy narrowcast server?

1130

what is the use of catlog or catlogfile?

2380

how to connect datamarts

2794

What is the dense rank?

1233

What do you mean by the term data warehousing?

1072

 Informatica Checkpoints

3331

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