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

In BTEQ, how are the session-mode parameters being set?

1146

Give a justifiable reason why Multi-load supports NUSI instead of USI.

1156

Mention the procedure via which, we can run Teradata jobs in a UNIX environment.

996

In Teradata, how do we Generate Sequence?

1051

Highlight the limitations of TPUMP Utility.

1116

Explain PDE.

1086

What is meant by a Highest Cost Plan?

1064

During the Display time, how is the sequence generated by Teradata?

1064

How is MLOAD Client System restarted after execution?

1160

What is meant by a node?

1047

What are SAS/ACCESS and SAS/CONNECT?

1151

How might you use MOD and INT on numeric to mimic SUBSTR on character Strings?

1377

Do you need to know if there are any missing values?

1044

What do the PUT and INPUT functions do?

1342

Which date function advances a date, time or datetime value by a given interval?

1158

Un-Answered Questions { Data Warehouse }

how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.

1689

Clarify the aggregator change?

1034

Are you involved in writing the inferential analysis plan? Tables specifications?

3965

Separate from a database, an information bazaar, and an information stockroom?

1092

What is the difference between hashfile and sequential file?

1266

How do you import and export the datastage jobs?

1163

Is there any default username & pwd for bo designer & supervisor?

1031

What is the procedure for creating independent data marts from informatica 7.1?

1068

Which commands are used to import and export the datastage jobs?

1414

Can you define set to be cardinality?

1016

--------------Diff b/w ODS and OLAP?

3211

Is it possible to join multiple Databases in a Catalog?

1126

How do you truncate a table?

1176

Explain what is the architecture of abinitio?

1217

What are different types of joins that are possible in obiee rpd?

842

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