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 the diff between etl tool and olap tool

2 7669

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

Arkema pte Ltd,

2349

In source system we have os - windows BO - 5.1.5. with webi 2.7.1 Repository database - oracle Reports database - Oracle and DB2 Nearly we have 1200 reports in present system , i want to move as it is to new hardware os- windows bo- 5.1.5 with webi2.7.1 repository - oracle reports - oracle and db2 let me know is there any migration techniques in same version. thanks in advance Usha

Arkema pte Ltd,

2285

How do you take care of security using a repository manager

2 8280

Can you use one mapping to populate two tables in different schemas

2 9664

What are differences between Informatica 7.1 and 6.1

3 10843

i am using Business Objects 6.1(a) facing a problem. ie when we save report in xls format then in xls sheet pictures are inserted into rep file are not come. Is it a bug. Give me answer as soon as possible. Thanks in Advance

TCS,

3 8650

what r the transformations that r not involved in mapplet?

Wipro,

8 32009

what is data driven?

TCS, Wipro,

5 53977

Hi i am new to Informatica. I have few question's in Informatica. Can any one respond, it will be appricaited. Q.Is Flat File Contains the Dynamic Cache?

6 10082

Generally how many Fact Tables and Dimensions Table you have used in the Project? Which one is loaded first Fact Table or Dimensions Table into the warehouse? What is the size of the Fact Table and Dimension Table? what is the size of the table and warehouse

TCS,

5 25355

what is the difference between SET and MERGE?

CitiGroup,

19 71680

what is SAS/Access and SAS/Connect?what are the uses?

3 10126

how many types of MERGE?

CitiGroup,

17 26763

what is Enterprise Guide?what is the use of it?

CitiGroup, Oracle,

2 18539

Un-Answered Questions { Data Warehouse }

Explain a linked cube?

966

How to execute the graph from start to end stages? Tell me and how to run graph in non-Abinitio system?

1269

where to store informatica rejected data? How to extract the informatica rejected data?

1016

Describe implicit attribute?

1025

What is the difference between sandbox and EME?

1280

What leads to a cross-join or how does a cross-join occur?

957

What are all the types of report?

1106

How to sort the dynamic objects alphabetically on the Universe based on and SQL Server

2303

What is set to be Cognos configuration?

1044

Explain load alternative records / rows into multiple targets - informatica

1168

Why filter transformation is an active one?

994

Assuming {et} is randomly drawn from N(0,1) and e0 = 0, generate 200 observations of xt = et − 0.5e(t−1) and draw a line graph of xt.

1888

What is standalone command task?

1327

Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?

2197

What is MPP. Is Redshift support MPP?

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