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 are the important features of datastage?

1061

Can you define merge?

1070

What are the different types of lookups in datastage?

1019

What are the different options associated with dsjob command?

1389

What is meta stage?

1140

What is the difference between datastage and datastage tx?

1020

What are the some differences between 7.x and 8.x version of datastage?

1217

What is the difference between an operational datastage and a data warehouse?

1097

What is the command line function to import and export the ds jobs?

1105

How you can fix the truncated data error in datastage?

1695

Define tm1 architecture?

Why did ibm cognos tm1 web change the technology from .net to java?

Can tm1 web be set up for load balancing?

Where is tm1 web logging information found?

Can you explain cognos tm1?

Un-Answered Questions { Data Warehouse }

Explain are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?

1837

8. How much supervision have you typically received in your previous job?

2217

What is an olap designer?

929

what is the hint? how to use it to reduce the query processing in program?

7679

How we check the errors before running the report?

953

Mention what dedup-component and replicate component does?

991

What are report caches and how many types are there?

929

What is meant by a Highest Cost Plan?

1000

How do y read Sequential file from job control?

15834

What is a transaction control transformation?

1153

5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C

1854

Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance

2179

Can you explain link buffering?

1117

What are the joins in teradata?

933

Can you state some of the innovations throughout history?

940

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