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 is bobble chart?

Syntel,

1 5918

how can you get the errors in job? when loops are araised we get error?

Syntel,

2121

what is stitch query?

Syntel,

2 8757

what is materialised view? why we use it in data warehousing?

HCL,

5 10455

what is view? types of views?

HCL,

3 8051

what is online view?

HCL,

1937

how can you create a report like if country=india then true if contry=spain then false?

Syntel,

2 6014

what is your project workflow and your role in the project?

Syntel,

5 11631

difference between stored procedure and function?

Syntel,

4 9107

how many types of formats you can run a report using cognos?

HCL,

4 10157

what are the components having in the report studio using interface eg:insertable objects pan,properties pan

HCL,

1 4969

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

HCL,

2080

what does my folder and public folder contains? difference between the my folder and public folder?

HCL,

3 9542

what is a join? what are the types of joins?

HCL, Satyam,

5 10283

what is an outer join? difference between left outer join right outer join with an example?

HCL,

1 11035

Un-Answered Questions { Data Warehouse }

explain the main difference between the nodup and nodupkey options? : Sas-administrator

1162

Why AWS redshift is named after Redshift?

After applying date prompt and when we run the report we fet from date and todate prompts..so when we enter todate

2031

it will become easy if uuu provide website linkssss and list of consultanciessssss

1979

Have you used macros? For what purpose you have used? : sas-macro

1041

Explain er diagram?

991

What is the purpose of cluster analysis in data warehousing?

1008

What is meant by Reportstudio shortcut?

2188

Mention some common errors that are usually committed in sas programming.

1045

Differentiate between sas functions and sas procedures.

1242

how would you create multiple observations from a single observation? : Sas programming

1005

Can you define drill across?

980

what are the different authentication modes available in microstrategy?

1107

can u please tell me about ........ how can explain my project before interviewer my projects are insurence domain & sales domain?

2185

What is the use of the %include statement?

1170

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