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 8116

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 4778

Which is the best training institute for SAS in hyderabad.

Stansys Software Solutions,

112 230713

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

Infotech,

3 8195

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

IBM, Infotech,

4 36330

Why we need XMLs?

IBM,

3 8009

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,

2111

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

1 5701

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 12429

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

CTS,

5 46250

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

IBM,

1 23305

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

2 16287

how to access the database directly from cognos reportnet

2 5455

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

2626

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

3 10381

Un-Answered Questions { Data Warehouse }

What are the differences between sql override and update override?

1151

What are the default statistics that proc means produce?

1092

name the scheduler for scheduling job and explain the scheduler? : Sas-di

1105

If you want to use a same piece of code in different jobs, how will you achieve this?

1327

Explain target update override in informatica

1190

Difference between e-r modeling and dimentional modeling?

988

What is a node in teradata?

1051

How far Redshift is better in performance as compare to other data warehouse technologies?

What is the fact table?

1142

What is the role of co-operating system in abinitio?

1496

What are public objects?

1100

which features do you use to check the data validations and errors? : Sas-administrator

1098

A session S_MAP1 is in Repository A. while running the session error message has displayed `server hot-ws270 is connect to Repository B`.what does it mean?

2275

what is different between sequential batch and concurrent batch and which is recommended and why?

4978

what is sas data set?

1152

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