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 8033

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 4700

Which is the best training institute for SAS in hyderabad.

Stansys Software Solutions,

112 227973

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

Infotech,

3 8067

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

IBM, Infotech,

4 36167

Why we need XMLs?

IBM,

3 7857

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,

2059

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

1 5632

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 12232

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

CTS,

5 46015

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

IBM,

1 23199

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

2 16169

how to access the database directly from cognos reportnet

2 5345

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

2547

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

3 10250

Un-Answered Questions { Data Warehouse }

Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks

1867

Can you explain new content durability?

1036

flat filevalidation in informatica

2158

Do we need an etl tool?

1023

How to test the debugging in sas?

1184

What happens if the owner of an object does not exist in the destination project?

920

What does “tail –f” command do and what is its use as an Informatica admin.

1113

What is cognos connection?

1303

What is powercenter on grid?

1184

What are system variables and sequencers in datastage

1118

How does proc sql work?

1101

Why need staging area database for dwh?

1084

how to explain health care project and which reports we can create in health care doain?

6806

What does the RUN statement do?

1309

Define query studio?

1009

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