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 4696

Which is the best training institute for SAS in hyderabad.

Stansys Software Solutions,

112 227728

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 36154

Why we need XMLs?

IBM,

3 7836

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 5625

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 12209

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

CTS,

5 45990

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 16150

how to access the database directly from cognos reportnet

2 5335

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 10237

Un-Answered Questions { Data Warehouse }

Why managing the data is important?

1015

where to store informatica rejected data?

1093

I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.

1166

Can you define confirmed dimension?

1082

What all are the different way to run a job?

1093

What is the difference between router and filter?

1268

Explain the difference between powerplay transformer and power play reports?

1023

What is the use of cognos decision stream?

1091

What are the business intelligent tools to which Redshift can be integrated with?

Are you sensitive to code walk-throughs peer review or QC review?

3145

What are junk dimensions?

1071

What is the sequence generator transformation in informatica?

1182

Explain difference between zabo and webi?

1099

What is an unconnected transformation?

1087

In banking domain how many Fact tables,Dimension table are present?

8799

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