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 logical data model?

1210

What are normalization, first normal form, second normal form and third normal form?

1057

My table got locked during mload due to a failed job. What do I do to perform other operations on it?

1098

What is the purpose of indexes?

1079

What type of indexing mechanism do we need to use for a typical data warehouse?

1168

Can we collect statistics on multiple columns?

1067

How do you create a table with an existing structure of another table with data and with no data?

1 1587

Can you load multiple data files for same target table using fastload?

1 1683

Can you connect multiload from ab initio?

1220

Why does varchar occupy 2 extra bytes?

1197

Why are oltp database designs not generally a good idea for a data warehouse?

1056

What's the difference between timestamp (0) and timestamp (6)?

1196

What do high confidence, low confidence and no confidence mean in explain plan?

1048

How many tables can you join in v2r5?

1073

What are the things to be considered while creating secondary index?

1101

Un-Answered Questions { Data Warehouse }

Tell me what is degree of a relation?

997

What are iconv and oconv?

1245

What are common programming errors committed in sas

1152

What are the 3 components in sas programming?

1198

I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .

1946

What are the different models used in cluster analysis?

963

Give an idea of system variables.

1036

What are the types of containers?

1237

What are the differences between joiner transformation and source qualifier transformation?

1176

Which is the database redshift is using?

What is the difference between mapping parameter & mapping variable in data warehousing?

989

Can you explain repository tables in datastage?

1411

Can you explain the advantage of using shortcuts?

1029

What are the mapping parameters and mapping variables?

1206

do you prefer proc report or proc tabulate? Why? : Sas programming

986

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