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)?

1017

Explain dimension table ?

983

What is bi?

1094

Explain is fact table?

932

What is difference between content store and content manager?

978

What is difference between informatica power mart and power center?

1004

What are the batches and it’s details?

974

Explain difference between powerplay transformer and power play reports?

953

What is metric store database?

1000

Explain informatica architecture?

997

Define cognos report net?

975

What is difference between data mart and data warehouse?

978

How to join multiple db in catalog?

1016

How do you call a store procedure within a transformation?

1004

Different circumstance which drives informatica server to expel records?

983

Un-Answered Questions { Data Warehouse }

How to view every column and the columns contained in indexes in teradata?

1056

how to create cubes in transformer ?

1073

what is sas data set?

1106

Explain entity, attribute and relationship in datastage?

1102

i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS

3756

What does P-value signify about the statistical data?

1364

explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?

2158

Explain what is sort component in abinitio?

1104

Compare dataset and fileset?

1039

for report generation which one you used proc report or data_null_?

7791

How many ways are there to do 'remove duplicate records in informatica'?

1014

What are the joins in teradata and how many types of joins are there in teradata?

1004

What is the difference between Standard and Metrics folder?

1082

How to fine tune mappings?

941

What is main difference mapplets and mapping?

1193

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