Search results for query: *

If i have object A within my Designer Application system, and I want to create a workarea that only contains the latest version of object A, how do i code this in the workarea rule ? (Presumably I use include_object, but what is the the exact syntax for this, as i cannot seem to get it working...

Wondered if anyone out there has any views/opinions on Materialised Views. Anyone had any bad experiences with them ? Anyone got any advice, things to look out for ?

Does anyone know where I can get information (white papers etc) giving crictical independent appraisals of Data Mining Software tools. I am putting together a paper for my company, in which I would like to put forward some suggestions on what we should use. For info. We are using an Oracle 8i...

Can you retrieve a file back from where you publish your site to ? (I am thinking of access database files, which may change constantly on the server)

I am trying to create a website whereby users can only access it, if they create a user, and then login. What is the best way to approach this with Frontpage (nb. i am using FP2000). When the users have logged in, i will want data (which is to be got from an Access database), restricted to...

Hi, am not a SAS expert, but have been given the unenviable task of working out why our business users cannot connect to our oracle database when running SAS via unix (not via the PC). We receive this error..... ERROR: The SAS/ACCESS Interface to ORACLE cannot be loaded. The SASORA code...

I have a query which has a lag statement nested within a CASE statement. Please see the output from sql below. Could anyone tell me why in order to get rid of the "ORA-00932: inconsistent datatypes" oracle error I have to place either a "to_date(....'dd-mon-rrrr') around the...

We will be undertaking an evaluation of the above software. Has anyone any views/opinions on it? Any good points/bad points ?

Am working on a Banking Transactional Data Mart. We have come across a potential issue with our Data Marts, and would like opinions on this. Within my transactional mart, we have a instances where some of the facts will have an associated record in one of the dimensions, but other facts will...

Am desiging a Banking Data Mart. More specifically one which analyses transactional data, across all products. (eg, Credit card, Savings account and Deposit account transactions). Ideally would like peoples thoughts on how best to design this. Bearing in mind I have such issues as.... How...

Hi, I am currently reverse engineering our schema into Designer 6 (Version 6.0.3.9.0). I am looking at reverse engineering the PL/SQL packages/procedures/functions. I am using Design Editor to do this. Now these procedures etc were reverse engineered a while ago. They have now changed and I...

Hi, I am an Oracle Analyst Programmer who is now looking into the use of Data Marts. The system I work on is a Banking Data Warehouse, and currently has a large number of derivations which are either computed daily or monthly, and then stored in a number of database tables. These derivations...