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

Comment on significance of oracle 9i in informatica when compared to oracle 8 or 8i?

1 4762

Explain about the concept of mapping parameters and variables ?

HCL, TCS,

3 13138

what is mystery dimension?

1 5845

what are cost based and rule based approaches and what is the difference?

1 5374

Two relational tables are connected to SQ Trans,what are the possible errors it will be thrown?

2 7942

what is the difference between stop and abort?

TCS,

3 16419

What is Micro Strategy? Why is it used for?

Infosys,

5 25140

what is the difference between Informatica 7.1 and Abinitio?

TCS,

1 9358

what is the logic will you implement to laod the data in to one factv from 'n' number of dimension?

3 7001

What is exact use of 'Online' and 'Offline' server connect Options while defining Work flow in Work flow ?

1 5331

what are the real time problems generally come up while doing or running mapping or any transformation?

2 6919

Explain one complecated mapping?

Fidelity, Wipro,

3 14971

Explain the flow of data in Iinformatica?

1 9735

What does dependency analysis mean in Ab Initio?

Syntel,

5 29216

How to Create Surrogate Key using Ab Initio?

IBM,

6 32390

Un-Answered Questions { Data Warehouse }

What is persistent lookup cache?

975

Differentiate between datastage and informatica?

1146

Explain etl?

940

Ist the schema that a data warehouse system can implements.

876

Write the advantages of partitioning a session?

1222

What is spool space? Why do you get spool space errors? How do trouble-shoot them?

942

How we can create indexes after completing the loan process?

1153

What is the use of powerplay web viewer in cognos?

1038

What are the string manipulation operators and functions associated with teradata?

1032

Explain data step in SAS

1029

what is PhaseIII, ODS, TLG, Macro and Proc in SAS

4434

Describe what the SQL Server tempdb and tlog files are used for?

2282

What are all the different types of prompt in cognos?

1000

how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?

2220

What's the layout of parameter file (what does a parameter file contain?)?

2344

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