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 a concurrent batch if a session fails, can you start again from that session

1 3044

When you move from devel to prod how will you retain a variable

1 2889

Partition, what happens if the specified key range is shorter and longer

Cap Gemini,

2504

Performance tuning( what you did in performance tuning)

Infosys,

1998

What are conformed dimensions?

1 3039

what are factless facts? And in which scenario will you use such kinds of fact tables.

1814

can you avoid static cache in the lookup transformation? I mean can you

1 2931

disable caching in a lookup transformation?

1 2472

In any project how many mappings they will use(minimum)?

1 2986

How do you implement unconn. Stored proc. In a mapping?

1 2779

Can you access a repository created in previous version of Informatica?

1 2711

What happens if the info. Server doesn't find the session parameter in the parameter file?

1 2864

How big was your fact table

1811

How did you handle performance issues If you have data coming in from multiple sources, just walk thru the process of loading it into the target

1 3522

How will you convert rows into columns or columns into rows

1 2696

Un-Answered Questions { Data Warehouse }

Can we have multiple application.cfm file in an application?

967

Performance tuning( what you did in performance tuning)

1998

name the components of report net?

Explain about enterprise scalability and roi of data integration suite?

885

What are transforms and what is the differenece between routines and transforms?

1068

How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.

1132

What do you mean by DTM and Load manager and what is difference between load manager and load balancer?

1164

What is the different lookup cache(s)?

1095

What is the difference between datastage and datastage tx?

1072

Explain the main differences between star and snowflake schema?

990

What are the components of Informatica? And what is the purpose of each?

1062

Explain difference between snow flake and star schema.

1059

What are routines in datastage?

1331

How would you code a macro statement to produce information on the sas log? This statement can be coded anywhere? : sas-macro

1053

what are the uses of fact table and dimension table in banking project?

4560

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