Search results for query: *

Yes, you have got me right. The situation that I am talking about is kind of reverse join. I remember having read that Star Schema is supposed to improve join performance, but then generally you would be querying on Fact Table with Dimension in where condition. But here the Fact is in where...

Hi, We are in the design stage of a Banking DWH. In our proposed star schema , the FACT Table stores Account Balances and Customer is one of the DIMENSIONS around it. For a particular report, I want to fetch Cusomer Details for customers having Account Balance > Constant. In such a scenario...

Thanks folks for all the inputs!! This has given me a lot of clues!

Thanks, We will be needing this data on day to day basis. In that case, how do we handle it in dimensional modelling? Regards, Gurudatta

Hi, We have a requirement where account balances (numeric data) needs to be stored across different balance slabs. E.g. if the bank has 5 customers with following balances Customer Balance 1 100 2 200 3 200 4 100 5 250 Then we need to...

Hi, What is Crystal Web Report Server? Is there any documentation expaling the architecture using Crystal Web Reprot Server. Is it restricted to ASP/WinNT or is it also compatible with Java/Unix...

Hi, What is Crystal Web Report Server? Is there any documentation expaling the architecture using Crystal Web Reprot Server. Is it restricted to ASP/WinNT or is it also compatible with Java/Unix platform? Please resolve these doubts urgently. Regards, Gurudatta

Hi, BO's (Business Objects) web Intelligence tool fits in the space of advanced qury and reporting tool on web. Is there any tool by Crystal Reports that fits in this space? If yes, is it capable of being integrated with a Unix based Application - by providing api's etc.? Regards, Gurudatta