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 we can call macros with in data step? : sas-macro

1125

What is the maximum length of the macro variable? : sas-macro

1094

How long can a macro variable be? A token? : sas-macro

1214

What are symget and symput? : sas-macro

1315

What is auto call macro and how to create a auto call macro? What is the use of it? How to use it in sas with macros? : sas-macro

1038

What do you code to create a macro? : sas-macro

1141

Can you execute macro within another macro? If so, how would sas know where the current macro ended and the new one began? : sas-macro

1199

How do you add a number to a macro variable? : sas-macro

1012

Can you execute a macro within a macro? Describe. : sas-macro

1111

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

1001

How would you code a macro statement to produce information on the sas log? This statement can be coded anywhere? : sas-macro

1048

what is the purpose of _error_? : Sas programming

1140

what are input dataset and output dataset options? : Sas programming

1105

if you were told to create many records from one record, show how you would do this using array and with proc transpose? : Sas programming

1064

how can you put a "trace" in your program? : Sas programming

1065

Un-Answered Questions { Data Warehouse }

Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?

1059

Explain what are the possible data marts in retail sales?

1011

Explain four-tier connection?

935

Explain swot analysis?

1166

Explain what is the architecture of abinitio?

1215

Describe 5 ways to do a “table lookup” in SAS?

1154

How can we schedule the graph in unix?

1000

What is Fullouterjoin?

1983

What are the Types of parallelism in detail?

1142

Explain why we use partitioning the session in informatica?

1094

Explain which versions are used in the bo dashboard work?

1094

What are the key elements of a data processing system?

1245

what are 5 ways to perform a table lookup in sas? : Sas-administrator

1238

What you know about transaction control transformation?

996

what are the component of range? : Sas-bi

1100

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