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

How do we create Links & Segments in Cognos Framework Manager?

1 12769

What are the advantages of Xcelsius & Crystal reports over Infoview?

Reliance,

1 7184

I have set of reports in BO4.0 and need to use "Hyperlink" functionality. I had to use native hyperlink functionality provided in BO4.0 but looks like it's available only in Rich Client.Currently,we have only Infoview B04.0 Launch Pad.Is OpenDoc the only hyperlink option on BO4.0 Launch Pad? Thank you.

3477

what the mean of version error in crystal?

Symphony,

2397

please let me know which type of question arise in interview on project manager round on insurance project with answer pls reply asap.

Accenture,

1 6058

Hi Frnds this que is recently asked at IBM there are two rows like aa6588fhfhf,gru282vbvv. Question is howcan we retrive the first number from two rows. Can any one help thanks in advance

IBM,

5 9265

Hi frnds this question is asked at IBM One query is there when we dont collect stastics on it,exlapin will show us LOW CONFIDENCE,When we collect stastics it shows HIGH CONFIDENCE.WHAT IS THE INTERNAL ARCHITECTURE ACTUALLY GOING ON ?????ASKED ON 23-08-2012 THANKS IN ADVANCE

IBM,

2 6453

IBM QUESTION As all we know PE takes the SQL Request and it will give responce for that query. what is the internal process happening.how it is taking that sql from the system????? thanks in Advance

Cap Gemini, IBM, Infosys,

2 9008

What is Model Versioning or Versioning in Cognos Framework Manager?

Systime,

2 9503

tell me few points when u become TL

Infosys,

2556

what make u disappointmnets in u r career

Infosys,

2197

Find a way to implement the following logic : You have column like : Column 1 AA|BB|CC DD|EE|FF WW|AA I need to get the length of the column without the ‘|’ .

5 9552

In aggregator transformation, I sort the data before aggregator and select sorted port but still I’m getting an error. What is that error?

2 6700

I am looking to buy a sas advance book. So any one can guide me that which one i should buy.

2116

I want to write one query How to get Matched records and unmatched records in table?

TCS,

4 11038

Un-Answered Questions { Data Warehouse }

What are differences between different gde versions(1.10,1.11,1.12,1.13and 1.15)?

1100

if you use oracle sql*loader , how do you transform data with it during loading?

2100

When can we choose the Redshift ?

What are the measure objects?

1202

What do you mean by static and local variable?

963

How to load the time dimension?

1012

Synchroness 1.What are hash prompts? Ans: Tree prompts in which hierarchies can be seen,they can be said as hash prompts. 2.User wants to see 5 more coloums in the report.We have package and data base,how will u implement using it in report.? Ans: 3.What is automatic optimization?what is optimization?what are the properties you set for optimization in report studio? 4.what is command to display first 10 records from a table? IGATE 1.In FM if we change a fact symbol to attribute,will it effect the report? 2.If a report is slow in generating output. How do u perform tuning? How do u reduce joins in sql? Using left outer join is it going to improve the report performance? IBM 1.How do you configure ? 2.How do you drill through report from RS to Analysis studio?

4749

How many universes can be created in a project?

1050

Explain piconet?

963

explain the environment varaibles with example?

1076

What are the limitations of joiner transformation?

1114

Explain the various types of filters available.

1006

Explain what are non-additive facts?

1033

how does sas handle missing values in a merge? : Sas programming

1048

What is metadata in context of a datawarehouse?

1060

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