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

please differentiate star schema and snow fleak schema with dimension table, how end user is depending on them in creating reports.

Exilant, Wipro,

1 5364

please anyone explain the equi join,outer joi(right outer join and left outer join),theta join and self join with database tables.

Wipro,

2 6384

If 2 tables are joined by Shortcut join, if query is generated based these join, what will be the join type and what will be the generated query? Thanks in advance?

iNautix, Wipro,

2230

tell me some dimension tables names in banking domain informatica project(dont tell like depends on project, tell me names of dimension and fact table names in your project)?

IBM, Patni, TCS,

3 26143

Need Ab-Initio Material - Harini

7 11786

any one pls tell me what are the table names in banking project?

2 5102

any one answer me how they can analyzing the project using data ware housing?

2480

what are the uses of fact table and dimension table in banking project?

TCS,

4556

Hi Techies, I got an issue so need your advice here. I have created a report in Report Studio and it's having 2 columns which are having long text as a value (BLOB data type). Report is displaying entire text items in HTML format, but when I'm exporting it into EXCEL it's give me ##########. How to correct (wrap) it in Excel? so when end users they are directly running that report in Excel so instead of seeing ######### for long text items they should see the entire text items in those columns. Please advice!

HCL, Wipro,

5 7829

what is the query for retrieve the unique values(not display the duplicates values) from single table?

IBM,

6 10049

"pravalli nagireddy" record is there in address column but i want display only 'nagireddy' from the main string what is query for that pls tell me

9 12455

Hi, I got a requirement wehre in in a drill through report , in parent report i have a column of numbers on which i have to apply drill through to child report.The condition is in that column if the number ia not zero the drill through link should appear (i.e., 1 to 9) if its 0 or negative number link should not appear. How ? Help would be appreciated

IBM,

1 5164

Hi ,how many shortcut joins used in a single universe? Thanks in Advance

2 5397

SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N

Infotech,

2132

1,If there are 3 workflows are running and if 1st workflow fails then how could we start 2nd workflow or if 2nd workflow fails how could we start 3rd workflow?

CompuSoft, EDS, TCS,

4 17302

Un-Answered Questions { Data Warehouse }

Approximately what date is represented by the SAS date value of 730?

1217

Explain how spool space is used.

1077

Whether dimension table can have numeric value?

1152

How do you start developing a datastage project?

1108

How you can read the variables that you need?

1125

How can we run the graph? What is the procedure for that? How can we schedule the graph in unix?

953

What is transformation?

1100

how to insert/update a csv file by comparing it with another csv file?

2568

what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?

2325

what is hierarchy flattening? : Sas-di

1083

What is the use of Cognos scenario?

1194

Why need staging area database for dwh?

1081

Can you explain the performance and scalability of co> operating system?

1128

have u done any performance tuning? how u ll do?

2299

what is the purpose of _error_? : Sas programming

1140

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