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 is univariate n where it can be used n how...?

2 7350

What r all the reporting procedures...?

3 6901

If we use only lookup transformation in a mapping ie, SourceQualifier-->Lookup --> Target. , here datas are taking very long time to load in target., so what are steps to improve the performance in that mapping???????

2 6524

can a fact table contains textual information

HCL, HCL BSERV, IBM,

6 14278

difference between function and procedure...

IBM,

1 6219

What are the new features of informatica 9 version?

2 8665

What is Relational Integrity?

1 4098

Suppose we are using a Dynamic Lookup in a Mapping and the commit Interval set for the tgt is 10000. Then how does the data get committed in the lookup if there were only 100 roows read from the src and the dynamic lookup dint have the 100th row in it?

Deloitte, TCS,

3 17802

can u apply SCD2 on flat file tgt? if yes wat is the procedure?

Deloitte,

3 26309

What is the difference between IN and Exists in Oracle?

Deloitte,

4 18311

Can we have a Mapping without a Source Qualifier?

Deloitte,

14 49877

Suppose in the next version of Informatica, RTR Xn is excluded. Then how will u route data to different tgts?

Deloitte,

2 13195

what is the use of Java Transformation in Informatica 8.x?

TCS,

2 13749

Hi I have Columns A, B, C, D, E in a Crosstab Report, Cost Budget Column A Column B Column C Column D Column E Total of A+B+D+ E Product 1 100 200 300 400 500 1200 Product 2 500 300 400 500 800 2100 Column A Column B Column C Column D Column E is coming from the Query Item: Category I dont want to include C Column value in the Total Column Column Chas to display in the Crosstab Report how to achieve it Any idea Thanks Sumith

2 5620

How applying "Level Span" in Cognos 8.3?

1 10372

Un-Answered Questions { Data Warehouse }

How is the partitioning with key different from round robin partition?

1218

How many clustered indexes can you create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id 347 what is hybrid slowly changing dimension?

1065

What is an er diagram?

1054

Please explain the different stages in creating a report in cognos report net?

1010

how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?

2377

What is the difference between connected and unconnected stored procedures?

1087

What are various types of gateways in cognos?

1064

How to generate the cubes in framework manager?

1048

What is data transformation manager process?

1167

how to export or import the jobs in .ISX file

1205

Explain what is informatica metadata and where is it stored?

1052

what is the difference between floor and ceil functions in sas? : Sas-administrator

1265

What are the difference between snow flake and star schema? What are situations where snow flake schema is better than star schema to use and when the oppositeis true?

1076

What is level based metrics.how will you create it?

882

if you use oracle sql*loader , how do you transform data with it during loading?

2108

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