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 39031

How to run the graph without GDE?

1 12347

What are the different versions and releases of ABinitio ?

2 9745

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

4 21478

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

Cognizant,

5 32193

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

TetraSoft,

14 71459

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

2 20151

How Does MAXCORE works?

CTS,

4 20129

what is meant by fancing in abinitio ?

3 17216

what are kinds of layouts does ab initio supports ?

4 21698

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

4 24155

What is a ramp limit?

2 14338

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

TCS, Wipro,

7 27591

How many parallelisms are in Abinitio?

3 12008

What are Cartesian joins?

3 11507

Un-Answered Questions { Data Warehouse }

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

1340

Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?

2027

Define olap designer?

1132

How can we schedule the graph in unix?

1000

Can the administrator easily maintain and manage microstrategy intelligence server?

1003

What is meant by junk dimension?

1184

Explain the difference between rolap and molap?

983

Explain is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?

1040

What are the new features of informatica 9.x at the developer level?

1043

What is expression transformation?

1103

How we can decided drilling options for an attribute?

984

Tell me what is degree of a relation?

997

What is the use of having index on table?

1004

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

1158

Mention what is SAS data set?

1132

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