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 12783

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

Reliance,

1 7191

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.

3488

what the mean of version error in crystal?

Symphony,

2405

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 6074

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 9296

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 6465

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 9026

What is Model Versioning or Versioning in Cognos Framework Manager?

Systime,

2 9516

tell me few points when u become TL

Infosys,

2573

what make u disappointmnets in u r career

Infosys,

2211

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 9582

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 6716

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

2123

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

TCS,

4 11055

Un-Answered Questions { Data Warehouse }

3. The vice president of sales has requested a graphical display of the same information provided in our last crosstab report (whatever I mentioned in above question) for an up coming presentation. We need to provide a chart report that shows which regions generate the most revenue and sales volume.

2633

What are the difference between ceil and floor functions in sas?

1361

how do you want missing values handled? : Sas programming

966

is there any difference between operational database and data base?if yes what r they?

2080

What is a dw? Why do we need it?

986

How can we determine what records to extract?

1089

Explain what is data validation strategies for data mart validation after loading process?

1040

What are the key features of chameleon that separates it from other algorithms?

1123

What is the flow of loading data into fact & dimensional tables?

1075

what cause the "error: connect:" and "error in the libname statement" when there weren't any such problems?

2199

Can we Save (save as) WEBI Doc as DESKI?

8194

I have 3 years of work experience at a startup and recently got certified in Data Science with SAS. I need to know how to get into the analytics industry

1769

How to reverse the string using SQL?

1540

After the generation of a report to whom we have to deploy or what we do after the completion of a report?

921

What are the advantages of cold fusion?

957

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