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 difference between bo and cognos?

1 4655

Can i merge two dataproviders if they do not have common column?

3 8301

1. can we create report using multiple universes and how ? 2. how can we move the objects from universe A to universe B in report ? 3. how can we create aggregate table at universe level ? 4. if there is only one fact table in that universe, what happens if we get fan trap ?

Virtusa,

1 8499

How to add 2 different colors for alternative rows? i.e in a report all rows colors in alternative colors(2 colors)

Mphasis,

4 12149

how to add a new query item by using 2 query subject? For Ex: i want to create a revenue query item in products query subject(revenue=Quantity*Unitprice). Quantity is in products query subject & unit price in orders query subject it will be possible in report studio(perment/temporerally) otherwise u have create in Freamework Manager... pls any body knows explain /answer me ?

4 7152

webI report not showing Barcode in PDF format, i have used BC39 font,but barcode is shown in HTML but not in PDF, please any solutions??

4460

when u face critical situation in ur project, how to solve them?

Toyota,

1 10308

what is surrogate key give example?

2 6506

what is sdibling function tell me the some functions

IBM,

3 7119

i have a sales project interviewe asked tel me the how many facts&dimensions used in ur project.

IBM,

2 5754

what is the core universe and what is the active universe?

1 5196

What is the prm file ? can anybody explain me ?

2 7513

what is the difference b/w the refresh and buffered data?

2419

What is the need of live office connector

3 7632

What is mean by stored procedure ? and how we can generate stored procedure universe?

3 5271

Un-Answered Questions { Data Warehouse }

How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?

2495

What are the prime responsibilities of data integration administrator? : Sas-di

1127

Can we use target hash file as a lookup ?

3390

Explain object variable error?

1060

How we can create indexes after completing the load process?

1207

define junk dimension?

What is data validation strategies for data mart v?

1186

How to publish a package by running Java Script?

2140

What are the difference between the sas data step and sas procs?

1263

Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.

2409

Name types of category in which SAS Informats are placed?

1199

What is sort component in abinitio?

1290

Tell us about the architecture of abinitio.

1159

Where do the datastage jobs get stored?

1274

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

1176

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