Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...



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,

2212

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.

2623

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.

2418

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.

2010

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 7584

what is difference between WEBi Report and Crystal Report?

Cognos, Nucleus Software, Red Cross,

3 34097

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

Nucleus Software,

2 9016

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

2 7734

What is shortcut join?could give any one example?

8 25351

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 9842

How to know informatica conslole password??

2115

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 4548

Can you please send me the migration related issues .

2073

why do u need the IOS upgradation in a FC switch

IBM,

2282

describe the Steps to confiure a Qlogic switch

IBM,

2383


Un-Answered Questions { Data Warehouse }

difference between impromptu and cognos8

2441


What are the reasons to use a chameleon method in data warehousing?

1057


how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.

3346


What is meant by lookup transformation? Explain the types of lookup transformation?

951


Does datastage support slowly changing dimensions ?

1105


What a static and local variable?

1077


Why is data processing considered beneficial?

1062


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?

2929


Difference between e-r modeling and dimentional modeling?

934


How do u convert the columns to rows in datastage?

1194


What is non-aggregate metric?

1016


Describe the ways in which you can create a macro variable?

1084


What is a sequence generator transformation?

1021


Name the types of transformation?

954


State the relation between EME, GDE and Co-operating system?

1133