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?

1 2190

How do you setup Lo-cockpit?

1 3256

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

IBM,

1 2107

difference between For each and for all

2 9588

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 16615

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 9924

what is the diff b/w verification validation in sas

SAS,

3 10553

in ods is there any lib's

SAS,

2 6385

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

2 4264

How to do deployment?

5 14452

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

Infosys,

9 30092

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 9308

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

3 7146

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

4 6597

what is portability of sas programmes?

Capital One,

2 8222

Un-Answered Questions { Data Warehouse }

How would you format some text using css to be verdana and bold?

1133

Hi friends, what are the new features in abinito3.0?

2855

Explain scd type 3 through mapping.

1065

What are the data types present in bo? What happens if we implement view in the designer and report?

1076

What is rollup component?

1327

Name at least 5 different types of transformations used in mapping design and state the use of each.?

1202

Have you have ever worked in unix environment and why it is useful in datastage?

1210

Explain in detail about scd type 1 through mapping.

1641

How do you load more than 1 max sal in each department through informatica or write sql query in oracle?

1654

Explain what is aggregate table and aggregate fact table ... Any examples of both?

1168

How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?

1194

Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com

2480

1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)

2790

What is a rollup component? Explain about it.

1232

what are the names of the reports that you prepared?

1185

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