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

what is the syntax of m_dump command?

3 39230

How to run the graph without GDE?

1 12441

What are the different versions and releases of ABinitio ?

2 9849

What is $mpjret? Where it is used in ab-initio?

4 21674

What is AB_LOCAL expression where do you use it in ab- initio?

Cognizant,

5 32426

What is the latest version that is available in Ab-initio?

TetraSoft,

14 71923

What is meant by Co > Operating system and why it is special for Ab-initio ?

2 20264

How Does MAXCORE works?

CTS,

4 20290

what is meant by fancing in abinitio ?

3 17341

what are kinds of layouts does ab initio supports ?

4 21880

what is the relation between EME , GDE and Co-operating system ?

4 24344

What is a ramp limit?

2 14456

What is the difference between partitioning with key and round robin?

TCS, Wipro,

7 27890

How many parallelisms are in Abinitio?

3 12161

What are Cartesian joins?

3 11658

Un-Answered Questions { Data Warehouse }

what is the meaning of upgradation of Repository?

3802

Explain adhoc reports?

980

Difference between sum function and using “+” operator?

1212

why a stop statement is needed for the point= option on a set statement?

1139

name the components of report studio?

What does microstrategy intelligence server allow users to do?

1037

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

1084

Explain how a source file is populated?

1420

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

1057

Do you know the features of sas?

1099

What function should we use to display the value entered or selected by a user in response to a prompt?

1039

Explain how spool space is used.

1113

What if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?

1064

Can you define folder?

1028

What is the function that transfers a string into a decimal?

1201

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