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

I use NOCUM/NOPERCENT option in the tables statement like this Proc freq data = deepak; tables x y /nocum nopercent; run; Here I get nopercent and nocum in the output only for variables x and y. How do i do it for all variables? Deepak

1 8025

If you set a label in the data step and call a proc freq on the data, how do you display the data without the labels and just the variables.

1 4697

Which is the best training institute for SAS in hyderabad.

Stansys Software Solutions,

112 227759

Please explain in detail with example about 1.Confirmed Dimension. 2.Junk Dimension. 3.Degenerated Dimension. 4.Slowly changing Dimensions

Infotech,

3 8061

Please explain in detail with example about 1.Confirmed Dimension. 2.Junk Dimension. 3.Degenerated Dimension. 4.Slowly changing Dimensions

IBM, Infotech,

4 36157

Why we need XMLs?

IBM,

3 7837

hi all of u, i want to learn the course in SAP(BI).because of there is no calls for BO. And the another region is it will be converted into SAP module. is it OK for me? is there any feauture in coming days? could any one plz send me the message

Wipro,

2057

What are the differences between webi and deski of XI R2 not the earlier versions

1 5626

I have two data providers with common dimension and measures. The only difference between two data providers is in condition 'Fiscal Year'.One data provider calculates for current year and other one calculates for previous year. So in prompts if I am passing 2008 as current year then the two data providers should be able to calculate for current year and previous year individually. So Can anybody tell me how to do calculation in data providers. ( I am using BO WebI report )

Exilant, Siebel,

6 12211

What is ThroughPut in Informatica, How it works, Where I can find this option to check ?

CTS,

5 45992

What is air_project_parameters and air_sandbox_overrides? what is the relation between them?

IBM,

1 23189

what are the steps in actual ab initio graph processing including general,pre and post process settings?

2 16151

how to access the database directly from cognos reportnet

2 5337

how to perform back drill through in cognos 8 what is the use of it

2543

. how will we hide the “report title ” in pdf format, but title should be remain unchanged in html format.

3 10238

Un-Answered Questions { Data Warehouse }

How can we store previous session logs?

1080

What are the functionalities of link collector?

1085

How to identify ppi columns?

1180

What are the different forms of output that can be obtained after processing of data?

1256

Is hadoop a etl tool?

942

Give some examples where proc report’s defaults are different than proc print’s defaults?

1073

How will you do sort in reports in obiee.

842

What's the Functional & Architectural Differences between Business Objects & Web Intelligence Reports?

2149

How online/offline mode impact development and delpoyment?

832

How create measures and demensions?

1045

What are aggregate transformation?

1037

Define mapplet?

1009

Why AWS redshift is named after Redshift?

What are transforms and what is the differenece between routines and transforms?

1066

What is a level of granularity of a fact table?

1158

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