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

How to hide the prompts

4 10817

Can any one gve me the complete information abt Certfication of Business Objects ?

2 4975

Can any one give the example for slicing and dicing of data ?(with simple query)

Cognos,

3 20047

Hi Every One When i Start the Workflow, Table is Going to be Stored in the target database But the columns are not going to the target database table in my PC , please give me the solution and waiting for solution

2 5531

how to duplicates from expression transformation without using sorter before that

1 14961

Can anyone help to find a statement to get all the predefined formats?

Verinon Technology Solutions,

3 7727

How many repositories can we create in Informatica??

IBM, Patni,

9 33615

How to Analyise 'Join' problem and which method is the best to resolve that ?

3 7389

What is the actual work done in Development and in the production depts in building a datawarehouse. Which dept is more interesting and career oriented .

1 4478

What are the differences between Cognos ReportNet 1.1, Cognos 8? and enhancements in cognos 8?

IBM, iFlex, TCS,

1 9610

WAT IS THE MEANING OF UPGRADTION OF REPOSITORY?

Wipro,

1 7083

HOE DO U IMPLIMENT SCHEDULING IN INFORMATICA?

Patni, Wipro,

7 31790

WAT IS TEXT LOAD?

Wipro,

3 9408

what is a Micro cube?

TCS,

5 13952

Hi Every One,What is Use of Factless Fact Table ? Why we use Factless Fact Schema in the Projects waiting for reply? thank you

6 14787

Un-Answered Questions { Data Warehouse }

What is target load order?

1268

A mapping contains source table S_Time(stat_year,end_year) target table TIM_DIM(date,day,month,year,quarter) stored procedure transformation: A procedure has two parameters I_end_year and output parameter as O_date ,day , month, year, quarter, If this session is running, how many rows will be available in the target and why?

1877

Difference between flat files and relational sources?

2255

Explain what is data step?

1215

how you burst the reports? If you are bursted reports is not reached to destination how you identify?when you import data into catalog you have complex columns names.how do you change the name of those columns?

1166

What are target types on the server?

1006

What is dimensional table?

1081

What is the Process to creating lookup transformation in informatica

1059

Explain what are the modules in power mart?

1062

Can you define pivot?

1129

Highlight the need for Performance Tuning.

1120

How can you communicate with web server (apache or iis) from coldfusion?

1131

Explain why we use partitioning the session in informatica?

1111

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

1118

What are the default statistics for means procedure?

1265

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