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 25578

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

iGate,

5 12353

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

2389

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

1 4911

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 14140

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

Nomura, TCS,

11 33739

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 10597

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 ?

2136

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 4874

WHAT ARE THE TYPES OF LIST REPORTS?

Patni,

4 8749

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

IBM,

1 6810

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

IBM,

1 6470

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

1 5722

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

HCL,

1 9932

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 19531

Un-Answered Questions { Data Warehouse }

Explain what sort of existing documents should business analysts refer to when starting on a new project?

949

Explain the methods to improve performance of a graph?

1062

Describe expression transformation?

1047

What is perform recovery?

1000

What do you know about sas data set?

1025

What is meta stage?

1135

How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?

1918

What is data stream and data adaopter?

1022

what do the mod and int function do? What do the pad and dim functions do? : Sas programming

1104

Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?

2285

How are models actually derived?

1947

How to convert a numeric variable to a character variable?

1136

Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?

2182

what is program data vector? : Sas-administrator

1014

what are the other factors of the database on which the loading performance depend?

1855

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