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

If session fails after loading 10000 records in the target,how can we load 10001 th record when we run the session in the nexttime?

HeadStrong, TCS,

8 31494

What are the different types of schemas?

ITC Infotech,

11 87700

How to enter same record twice in the target table,explain?

7 14252

What are the different threads in DTM process?

2 10007

When do we use dynamic cache and static cache in connected and unconnected lookup transformations?

3 12896

How to identify bottlenecks in sources,targets,mappings,workflow,system and how to increase the performance?

4 35655

what are presession,postsession success and postsession failure commands ?

1 6873

What are mapping parametres and variables in informatica?

TCS,

6 35900

Give me a broad concept of what a data warehouse is, and what it might be used for?

2 5345

What is a Data Cube?

1 6416

Explain in simple terms, the concept of Data Mining.

3 13074

how can one transfer LOB and user defined data from oracle to warehouse using ETL informaticabecause

iGate,

2187

which automation tool is used in data warehouse testing?

1 6453

what is data validation strategies for data mart validation after loading process

1 6927

what is the difference between etl tool and olap tools

3 10874

Un-Answered Questions { Data Warehouse }

------------------What is Inline Query?

2261

what is the custome stage in datastage? how can we impliment that one? plz tell me

2416

Where are the source flat files kept before running the session?

1144

Can we have two time dimensions in a schema(either star or snow flake)? For ex if we want joining date of employee and if we want today's sales with time whether can we have two time dimensions for accommodating above tasks?

2199

what will be the contents for a functional requirements specifications

2422

In Which Transformation We Can Use Having Clause In Informatica?

1299

What is a passive transformation?

1154

what are the cubes developed in a sap bw project and what is the requirement for developing it?

2137

What is target load order?

1302

Can we use target hash file as a lookup ?

3381

Identifying the bottlenecks in various components of Informatica and resolving them.

2667

How to perform incremental load in datastage?

1266

What is microstrategy?

1033

What is the role of unrestrictive users? : sas-grid-administration

1079

What are the other names given to data warehousing?

1159

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