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 operational data store (ods)?

961

Explain dimension table ?

923

What is bi?

1017

Explain is fact table?

878

What is difference between content store and content manager?

925

What is difference between informatica power mart and power center?

948

What are the batches and it’s details?

911

Explain difference between powerplay transformer and power play reports?

909

What is metric store database?

949

Explain informatica architecture?

936

Define cognos report net?

934

What is difference between data mart and data warehouse?

925

How to join multiple db in catalog?

956

How do you call a store procedure within a transformation?

945

Different circumstance which drives informatica server to expel records?

922

Un-Answered Questions { Data Warehouse }

What is tracing level?

1010

What is the use of cognos decision stream?

1041

What are the guidelines to be followed while using union transformation?

1068

what is the meaning of ending bulk load mode?

I have set of reports in BO4.0 and need to use "Hyperlink" functionality. I had to use native hyperlink functionality provided in BO4.0 but looks like it's available only in Rich Client.Currently,we have only Infoview B04.0 Launch Pad.Is OpenDoc the only hyperlink option on BO4.0 Launch Pad? Thank you.

3407

How security is concerned with Reportnet? Explain its implementing steps.

1986

Mention what information does a .dbc file extension provides to connect to the database?

1250

server hot-ws270 is connect to Repository B. What does it mean?

2445

What are the advantages of cognos?

920

What are the different types of parallelism in ab initio?

1154

What do you mean by dimensional modeling and relational modeling?

833

hi here is a problem can anybody solve this? i want to report the data through third party file. by using data _null_ or proc report or macro automation process. but i want to insert the 'titles and footnotes' in between the data and also starting of 2nd and ending of 2nd and starting of 3rd and ending of the 3rd page. tell me how and write the code?

2062

What is the difference between Datawarehouse and OLAP?

888

Explain the various types of filters available.

925

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

936

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