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

This question is asking in many interviews,,,,, What is your challenging task in report studio? anybody pls tell me some 2 or 3 challenging tasks,,,,

2296

What are the problems you have faced recently while developing reports in report studio? And how did you solve those problems? This question is asking in many interviews,,,,so pls help me,,,,,

2 12633

If you got any problems while developing the reports, then what will you do? How will you debug the problems? This question isasking in many interviews,,,, pls help me,,,

2133

These are the questions asking in many interviews, so pls help me,,, How did you get requirements from the client? How did you send reports to the client? How did you interact with your client? I mean through e- mail or phone or in any other way?

IBM, Logica CMG,

6 10142

How to execute the MACRO through Infoview?

1 9312

how to calculate the optimum cache size in aggregator transformation?

1 7849

If i doest required Cumilative frequency in my table, generated by using PROC FREQ what i had to do?

HCL,

8 14007

How did you use the round function?give an example(don't say it will round to the nearest intger) eg1:round(84.55,.1) =84.6 eg2:round(92.64,.1)=92.6,How it is happening like this tell me the logic,that is how the round function works when we have deimal values?

BoA,

2 29120

What are MIs reports? what is the use of MIS reports and How can u generate the MIS reports in SAS? If any body know explain with the eg.

ABC, ASD Lab, CitiGroup,

2 15219

Hi... this is chandu, did MSc Microbiology, trying to get job in SAS tool, PLZ Tell me whether IT industries will give consider my education to gain a job....?

2 5997

What is a macro routine?

2725

if x=round(26.3,10)-1 then x= how much and how explain?

BoA,

5 10592

what is document design in boxi,have u participate in that

Accenture, TCS,

2185

what r the disadvanges in boxir2

Accenture,

3 9140

what is isolated joins in check integrity

Accenture, Polaris,

2 18135

Un-Answered Questions { Data Warehouse }

What are the components used in web tier?

992

Why is data processing considered beneficial?

1062

explain about citrix scheduling tool in datastage

2457

Difference between SAS STATA & SPSS?

1120

What are fundamental stages of data warehousing?

1046

How do you schedule or monitoring the job?

1210

What is datastage?

1083

What is a source qualifier?

1104

How to schedule the report in b.o?

1038

Mention what is SAS data set?

1132

Explain the key challenges that you face while performing etl testing.

1009

What is the difference between orabulk and bcp stages?

1027

To which project that prefix will set is to private project or public project or both?how and where to set?

1851

How you Implemented SCD Type 1 & Type 2 in your project?

4129

How will you port changes for dashboards,reports,rpd from development to production?

942

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