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

With out using Funnel Stage, how to populate the data from different sources to single target

Wipro,

12 26499

How to change English language to Chinese in BO Desiner (Universe)?

iGate,

5 12789

How/where can i install Informatica software with oracle or teradata as database

2508

Informatica software installation 8.1/7.1.3/7.1 with oracle 10g database (optional Teradata v2R6)

1 5056

There are n numbers of flatfile of exactly same format are placed in a folder .Can we load these flatfile's data one by one to a single relational table by a single session??

TCS,

9 14766

If we are using an aggregator but forget to mention the group by port .what will be the output??

Nomura, TCS,

11 34642

I have 2 Sources,If 1st one Read sucessfully,Then only it has to move to read 2nd source.How can i do in INFORMATICA.

4 10937

Please Answer this Questions: 1.In FWM We have to create Hierarchies, Condition is we don't know the correct levels in the Hierarchies, in this case how can we find out the levels (year->Quarters->month->day)in data? 2. In FWM Standalone Filter is for Reusable purpose & Embedded Filter we cant resuse.but is this possible to convert the Embedded filter to standalone filter? 3.What are the differences between Relational Database Model & Multi Dimensional Database? 4.In Drill Down/ Drill Up, How to specify the limits for example in a report there is 6 Drill down is possible, but i want only 3 Drill downs, the report should not allow 4 Th Drill Down.How to make this ? 4. What are the limitations in Select and Search Prompt ?

2287

In Report page i have three types like (List,Cross tab,Chart), using Conditional Block i need only type of Report (Chart)at run time.How to do this I need The Complete Steps to do this?

1 5018

WHAT ARE THE TYPES OF LIST REPORTS?

Patni,

4 9102

WHAT IS METRIC STUDIO?WHAT IS SCORE CARDS HOW TO IMPLEMENT IT AND WHAT IS THE USE OF SCORE CARD?

IBM,

1 6985

What is metric studio?what is score cards and how to implement score cards what is the use of score card?

IBM,

1 6633

How we can add a comment in universe...?

1 5917

Graph was failed how it is achived ? send answer with phone number? i want speak with directly who is intrest on abinitio?

HCL,

1 10242

I had 10,000 records r there i loded today 4000 records, i need load to 4001 - 10,000 next day how is in Type 1 and how is it on type 2?

CTS, IBM,

5 19986

Un-Answered Questions { Data Warehouse }

Mention what is a partition and what are the different types of partition components in abinitio?

1232

What is the differences between star and snowflake schemas?

1122

How you can run a graph infinitely in ab initio?

1654

What is a dimension?

1081

Explain how you can run a graph infinitely in ab initio?

1169

What are all the problems you faced while validating tables and reports?

3515

What is connection profile? : sas-grid-administration

1235

What are the key features of chameleon that separates it from other algorithms?

1183

How to deploy from one server to another server?

2547

what is sas application server? : Sas-di

1143

Why is dimensional normalization not required?

1146

Are you involved in writing the inferential analysis plan? Tables specfications?

2597

What are the multiload utility limitations?

1117

What is the use of datastage designer?

1229

Explain the main difference between inmon and kimball philosophies of data warehousing?

1018

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