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


Data Warehouse Interview Questions
Questions Answers Views Company eMail

2. We have asked to create a repots showing sales by region in order to determine which regions are generating the most revenue and highest sales volume. The report needs to include the revenue and quantitiy sold of each subcategory with in category.

HCL,

1711

3. The vice president of sales has requested a graphical display of the same information provided in our last crosstab report (whatever I mentioned in above question) for an up coming presentation. We need to provide a chart report that shows which regions generate the most revenue and sales volume.

 2116

The vice president of sales has requested a report that shows sales performance by representatives in each country for year 1998. He would also like to see the performance for reprasentatives in Asia in order to present an award to the top sellers when he visits next month.

 1780

A product manager is analysing the sales made for each product, he has requested a report containing data for specific products. To do this we will create a report that includes a prompt page that filters on specific products within specific product subcategory and category.

 1612

A Main workflow "wkf_Main" has multiple sessions (S1, S2...., can I make changes and promte one session (S5) at any time or have to promote whole Workflow "wkf_Main" every time?

 4 5800

what is difference between WEBi Report and Crystal Report?

Cognos, Nucleus Software, Red Cross,

3 32548

What is diff between InfoView and Zero BOAdmin (ZABO)?

Nucleus Software,

2 7891

what is diff between Decode and case ? Give some Example?

 2 6715

What is shortcut join?could give any one example?

 8 23174

if we have a value prompt in a prompt page and if we need to pass that prompt value to a sql used in report, what is the sql code? give me example?

ComNet,

3 8522

How to know informatica conslole password??

 1664

My problem is as follows I made two pages of the portal; in the first page i have two reports and from one of these i would like to communicate in some way (i.e drill- through?) with the second page that contains four reports (prompt value [product] and three chart [sales revenue, sales quantity and budget]). Particularly I would like to communicate with the report that contains the prompt, passing the Product. How can i drill from the first page of the portal to the second page ? More generally, is it possible to move from one page, containing 2 report, to another page with 4 report, through a drill-through or any other mechanism? Thank in advance.

 1 3924

Can you please send me the migration related issues .

1628

why do u need the IOS upgradation in a FC switch

IBM,

1856

describe the Steps to confiure a Qlogic switch

IBM,

1923

Un-Answered Questions { Data Warehouse }

How does hashing happens in teradata?

607

name the window by which you can create your own custom scripts?

5

What are the static cache and dynamic cache in informatica?

695

What is the multi-insert?

592

What is the difference between datawarehouse and bi?

505




Define Pmrep command?

621

how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?

1908

What are the steps involved after the disk manager passes the request?

560

What do you mean by mstr?

577

How you can read the variables that you need?

642

Compare dataset and fileset?

555

How we are going to decide which schema we are going to implement in the data warehouse?

472

Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?

1624

What is the procedure for creating independent data marts from informatica 7.1?

553

How do you call a module named �testmod.cfm� with the parameters param1=�yes� and param2=5?

569

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