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?

2582

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 7728

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

ASD Lab, IBM,

1 6413

how to merge 2 crosstabs thans

HCL,

2654

how to create calculate column in report studio

4 9196

what is the use of lock and unlock

1 5854

which type of project we r going to snowflake schema

IBM,

1987

can we create a chart without measure

3 7867

diff b/w dimension and regular dimension

1 5293

diff b/w layout calculation and query calculation

Cap Gemini,

2 7431

how to connect datamarts

HCL,

2807

diff b/w grouping and aggregation

HCL,

1 6175

how to improve performance in report studio level

Wipro,

1 6519

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

2 15268

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 7221

Un-Answered Questions { Data Warehouse }

What do you code to create a macro? : sas-macro

1155

Explain md doctor?

990

What is the difference between informatica and datastage?

1240

What are all the types of report?

1106

Whenever we load data into oracle table from staging table using exchange partition...then I read somewhere that data actually doesn't move in this and this command only reset the pointer in the data dictionary...so if data doesn't move then how data is loaded into the main table ? I mean wat is the point of pointer update in data dictionary?

1017

Explain your project of banking domian.

1658

How to set up valid email address and printer in Cognos, so can delivery the report by email or print it out?

3970

Where can we find the throughput option in informatica?

1075

How might you use MOD and INT on numeric to mimic SUBSTR on character Strings?

1385

What are the kinds of layouts does ab initio supports?

1010

What is a table alias in obiee? And where and how will you create it.

908

For what purpose would you use the RETAIN statement?

1535

How to process records in batches like 1-20 records in first execution and 21-40 records in second run.. so on

999

hi i have 2 users and 4 reports in dashboard.i have to give rights 2 reports for every users. is it possible give the rights in dashboard.if yes plz let me know how is it possible . thanks in advacne for appreciation. bye rohit

2064

What is the difference between dependent data warehouse and independent data warehouse?

1022

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