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

main purpose of aggregate awareness(not include make possible of use of aggregate tables)

Accenture,

2 8543

in report level u find from which context u use,why it appears,what is the reason,how u resolve in report level

Accenture,

3 9791

disadvantages of boxi

Accenture,

2 8360

in universe perameter u dont give the option multiple contexts ,what is the impact in report level

Accenture,

2 8954

what are the types of universes? what is the difference between metri universe and simple universe? in what context we use metric universe?

Fujitsu, Virtusa,

4 13840

what is the difference btween olap and oltp?

CTS, Fujitsu,

6 18052

How can write SQL Overwrite to get Daynamic rows from the source in SQ transformation!(Any Example)

1 6191

IN A TABLE CAN WE USE PRIMARY KEY IN ONE COLUMN AND IN ANOTHER COLUMN BOTH UNIQUE AND NOT NULL CONSTRAINS.IF YES HOW?PLZ GIVE ME A EXAMPLE.

2 8917

IS IT POSSIBLE THAT THERE R TWO PRIMARY KEY WILL BE IN A SAME TABLE?PLZ HELP ME BY GIVING THE ANSWER.THANK U.

10 17902

parallel jobs run on cluster machines. server jobs run on smp and mpp. What do mean by cluster mechines and SMP and MPP..?

3 12073

I'd like the load to be triggered by client. By placement of a file or somehow. How is it done in Informatica? I'm using version 7.1.4 This is so urgent - I really appreciate your help :-)

Alcatel-Lucent, ECI Telecom,

3 9141

what do u mean by variable functions ?

2 6113

what is datastage job Monitoring

CTS,

6 22513

what is usage of datastage with materialized views

HP, TCS,

4 16661

1.what is the use of migration.(converting one version to another) 2. what r the migration issues faced while migrating from Bo5.x to BOXIR2 n how 2 resolve it. 3. provide some .ppt/material to understand abt migration easily.

16 16923

Un-Answered Questions { Data Warehouse }

Why did ibm cognos tm1 web change the technology from .net to java?

Is it possible to define a single node as a Gateway node as well as worker node?

1133

What do you mean by ttu in teradata?

1056

What happens in a conflict? How do you handle that?

1064

is there any difference between operational database and data base?if yes what r they?

2083

If we are migrating lower version of Cognos reports (e.g. from Ver 7.0 to Cognos 8) then how we migrate Impromptu Catalog (ver 7.0) in Cognos 8? Do we create FM model for that? Please explain.

2120

how do u estimate the depth of the session scheduling queue? Where do u set the number of maximum concurrent sessions that Informatica can run at a given time?

2047

Describe expression transformation?

1138

What are the ways in which macro variables can be created in sas programming?

1124

Migration of Reports from business objects 5.1.5 to samee version in different hardware?

2351

What is size of a transaction and an array means in a datastage?

1325

How to use consolidations in microstrategy report?

1057

What are the validations that you can perform in oracle and in informatica ? Advance Thanks

2090

How many Key we can define in remove duplicate stage?

1404

What is auto call macro and how to create a auto call macro? What is the use of it? How to use it in sas with macros? : sas-macro

1054

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