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 4543

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

3 8120

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 8402

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

Mphasis,

4 11962

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 6946

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??

4408

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

Toyota,

1 10218

what is surrogate key give example?

2 6414

what is sdibling function tell me the some functions

IBM,

3 6968

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

IBM,

2 5599

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

1 5079

What is the prm file ? can anybody explain me ?

2 7379

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

2344

What is the need of live office connector

3 7464

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

3 5135

Un-Answered Questions { Data Warehouse }

how to debug and test the sas program? : Sas-administrator

1038

In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?

1039

What are the difference between snow flake and star schema?

1006

What is a Pivot?

1151

Write some methods to apply securities in framework manager model?

1118

What makes sas stand out to be the best over other data analytics tools?

1072

what is the use of structures?how many nodes can u create in a structure?

2239

describe about physical data integration? : Sas-di

1045

How to import multiple xls files into sas. Out of those files, how to get different values from a single variable and how to find number of rows per value type? We can do this using group by for one xls file with proc sql. Was wondering how I can achieve this for multiple files at the same time. Any ideas?

2930

Explain when to use local filter and when to use global filter?

1360

What are cluster in redshift? How do I create and delete a cluster in aws redshift?

: and & modifiers.

1395

what are the fact table & dimensional table in pharmaceutical and hospotal related products???

2136

What are the advantages of raid 1, 1/0, and

980

What is the difference between datawarehouse and bi?

955

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