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

Can you describe me a problem you faced when you were trying to load data from R3 system and another system outside sap systems?

2133

How do you setup Lo-cockpit?

3180

Can anyone give me the url for cognos forum which is similar to forumtopics.com/busobj for business objects?

IBM,

2059

difference between For each and for all

2 9463

1.How many ways are there to create variables? 2.What is CLM,how can we use it? 3.what are the advontages of data step? 4.what is the extension of editor window in SAS 9.1.3? 5.How do you copy a particular data set from one library to another? 6.what is the use of double option? 7.Advontages of Proc Report? 8.what is the basic use of where statement? 9.How do you terminate the statments in SAS Programming? 10.What is the difference between symput and symget? 11.How would a identify the local and global variable? can any one answer for the 4'th question

CitiGroup,

8 16339

I would appreciate if any one answer for this, I have faced the question like this, the question was Tell me some complex reports, which u faced?

SAIC,

5 9718

what is the diff b/w verification validation in sas

SAS,

3 10435

in ods is there any lib's

SAS,

2 6257

What errors and types of errors you faced in Cognos ReportNet?

1 4203

How to do deployment?

5 14276

Which type or t/s is used to convert rows into column & column into rows

Infosys,

9 29788

In the SEQ generator which property has to be set to generate seq No. when the input data is more than the max limit.

Accenture,

3 9183

Hi All can anyone tell me where i will get Informatica training in Mumbai?

3 7003

Hi,Can anyone tell me training centre for cognos in Mumbai?

4 6455

what is portability of sas programmes?

Capital One,

2 8109

Un-Answered Questions { Data Warehouse }

What is process model?

1995

Highlight a few of the advantages that ETL tools have over Teradata.

1102

Explain what are the steps to be taken to schedule the report?

1120

What would be the result of the following SAS function (given that 31 Dec, 2000 is Sunday)?

1170

What is enterprise data warehousing?

1059

What are the uses of sas?

1291

What is defined as Cognos Impromptu?

1097

What is Analysis Services?

2156

What are the different versions of sas that you have used until now? : sas-grid-administration

1355

What are the advantages of using informatica as an etl tool over teradata?

1038

How does a sorter cache works?

1079

What is fact table? Explain the different kinds of facts.

1091

What are the types of data processing you are familiar with?

1230

What is the meaning of up gradation of repository?

2007

how will you implement security in obiee,so that subjects areas accessed by one group are not accessed by another group.

880

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