1. Categories >> Software >> Data Warehouse
  2. Suggest New Category


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 4659

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 5337

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,

1779

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 24640

Need Ab-Initio Material - Harini

 7 9508

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

 2 4102

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

 2030

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

TCS,

4106

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 6256

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

IBM,

6 8090

"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 9702

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 4413

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

 2 4468

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,

1690

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 15829

Un-Answered Questions { Data Warehouse }

What are the statements that are executed only?

676

What are the types of catalogs in cognos?

675

What is the difference between Section and Section using Master/Detail in Cognos 8 Report Studio? I tried these both options many times on lists and crosstabs, but dint find any difference. So please give the answer in detail with example.

4078

What is a method for assigning first.VAR and last.VAR to the BY group variable on unsorted data?

2010

What is a logical size of a table and what does it depend on?

538




I have 2 doubts regarding the "Input Control" functionality in BI4: 1) Can the Input Controls in BI4 be manipulated? I mean, can we change the IC display as BOLD or change the values from Italics to regular? Or change the colors? 2) How to get hierarchy type control in IC? Let's say my first IC is for Country and second is for State. If I select a particulat country from Ist IC,second one should show me states belonging to selected country. Is that possible? Thanks in advance!!!

1759

Can you explain tagbatch restructure operator?

705

what are _numeric_ and _character_ and what do they do? : Sas programming

678

what versions of sas have you used (on which platforms)? : Sas programming

586

What are the methods by which it non-durable model could be changed into the durable model?

527

Describe data concatenation?

575

when u connect the repository for the first time it asks you for user name & password of repository and database both.But subsequent times it asks only repository password. why?

1757

What is level based metrics.how will you create it?

465

What is the difference between Datastage 7.5 and 7.0?

675

Explain the use lookup tables and Aggregate tables?

551

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