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

I wanted to learn Ab Initio, Could you please send the material to my personal email id.

2 6248

how can i answer for question like teradat architecture in interveiw

TCS,

4 10555

plz explain parlla distribution and subtable concept in teradata

TCS,

3 9675

What is recurring sheduling and batch scheduling?

TCS,

2 7167

How to load last 10 records of flat file in to the target?

iNautix,

5 25026

In banking domain how many Fact tables,Dimension table are present?

TCS, UST,

8817

how can we calculate fact table size?

1 6355

How to get two dimension objects in a same block which are comming from two different contexts ?

1 5523

what is differences between the group span and levelspan

1 10449

what is fact less fact give me proper example?

2 6434

how i will stop my workflow after 10 errors

HP,

2 7000

why we r using presql&postsql in source qualifier?

HP,

1 6153

how i will stop my workflow after 10 errors

HP,

1 6981

I have file with empid,empname and I want to load these two fields along with sal in my target 1)salary must be same for all the records 2)I want pass the salary at run time

TCS,

7 11500

what is A Datastage?

2 4957

Un-Answered Questions { Data Warehouse }

What is the basic syntax style in SAS?

1182

Give some difference between oltp and olap.

1019

What do you mean by data sorting?

1227

What is Linear Regression?

1181

How can I remove header from output data set?

2638

What is data stream and data adaopter. Is it same are different? Explain?

1027

What are the enhanced features in teradata v2r5 and v2r6?

1143

Can I create a master report in webi having 15 dimensions and 150 kpi's with 100GB of data and store it in cache ,So that I can use Cache for building new reports with less dimensions and Kpi's without hitting database againg just using cache??Please suggest...

2144

how to create the AE dataset by using SDTMIG specifications and SAP plan by using UNIX platform?

2776

can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.

3881

What is decode in informatica?

1181

name the window by which you can create your own custom scripts?

What do you mean by enterprise data warehousing?

1075

What is the difference between snowflake and star schema? What are situations where snowflake schema is better than star schema when the opposite is true?

1117

Could any one explain me how to create cascading prompts?

1082

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