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 7944

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 4600

Which is the best training institute for SAS in hyderabad.

Stansys Software Solutions,

112 224302

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

Infotech,

3 7917

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

IBM, Infotech,

4 35939

Why we need XMLs?

IBM,

3 7675

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,

2009

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

1 5537

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 11947

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

CTS,

5 45662

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

IBM,

1 23072

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

2 15984

how to access the database directly from cognos reportnet

2 5216

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

2467

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

3 10088

Un-Answered Questions { Data Warehouse }

How do you change a non-reusable transformation to reusable transformation?

948

Highlight all the modes that are present under Confidence Level.

919

how much memory space occupied real time project (roughly)?

2180

What are the approaches used by optimizer during execution plan?

837

What do you mean by query studio?

890

How will you create report from two subject areas

771

Explain the features of connected and unconnected lookup.

878

What is Data Caches size?

1035

Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks

1899

Describe the between keyword in teradata?

982

Explain why should you put your data warehouse on a different system than your oltp system?

866

Explain the difference between powerplay transformer and power play reports?

957

what is operational data and operational system? : Sas-di

1059

Can the administrator easily maintain and manage microstrategy intelligence server?

898

Can there be sub steps of etl steps?

941

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