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?

2117

How do you setup Lo-cockpit?

3163

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

IBM,

2047

difference between For each and for all

2 9433

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 16282

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 9685

what is the diff b/w verification validation in sas

SAS,

3 10406

in ods is there any lib's

SAS,

2 6220

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

1 4188

How to do deployment?

5 14226

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

Infosys,

9 29723

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 9147

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

3 6976

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

4 6416

what is portability of sas programmes?

Capital One,

2 8074

Un-Answered Questions { Data Warehouse }

Can there be sub steps of etl steps?

1028

What is difference between model & package?

1029

What are the join problems comes appart from loop,chasm & fan Traps

2132

For what purposes have you used sas macros? : sas-macro

1001

Explain target update override in informatica

1126

What are default access rights in teradata? What explicit right can be given to a user?

1112

Why facts table is useful in representing the data?

1005

What is sequence generator transformation in informatica?

1078

------------- How to identify the Revenue Column in Report?

2387

Mention what are the different types of parallelism used in abinitio?

1117

What is a view as it relates to system modeling?

979

Explain difference between view and materialized view?

961

During the running session, output files are created by informatica server. Enlist few of them.

982

Have you used macros? For what purpose you have used? : sas-macro

1041

Can you define query studio?

960

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