datamart & datawarehouse
What do you mean by DATAMART & DATAWAREHOUSE & what is the difference betwen two??
View Answer
| Mar 21 2008 7:06 AM GMT
| asked by
Pratap123
Database Management Systems, Data mart, Data warehouse
oracle calculated item
hi ihave alist of variables some of them calculated from others i recieved them from certain source in certain date and i have alist of indicatores which are calculated from the variables (for the same date,& source) but every indicator has diffrent equation & the user need to modify the equation f...
View Answer
| Jan 13 2008 1:12 PM GMT
| asked by
Rosealzubi
DB2, USE DATABASE, Database Management Systems
Archive Storage and Retrieval
I am the IT Director at my church but have a limited amount of experience with software. My back ground is Hardware, Networking, video, audio and other. One of my commitees came to me a couple of weeks ago and is asking me for help. The project is to take the Church's past history, since 1905,...
View Answer
| Dec 17 2007 7:53 PM GMT
| asked by
Itsquire
Document archive, Scanning, Database Management Systems
PowerBuilder Printing Problem
hi all, i have a problem, when i print a powerbuilder report using a network printer, from some PCs the report is blank where from some others it is printed properly. i don't think so that the problem is in PowerBuilder because all PCs uses the same EXE. thanks in Advance.
View Answer
| Aug 11 2005 5:15 AM GMT
| asked by
Ghassanhaith
Hardware, Database Management Systems, Sybase
SQL Server worst practices
Hello,My name is Nick Bellistri and I am the assistant site editor for SearchSQLServer.com. Jeremy Kadlec, a performance and tuning expert at SearchSQLServer.com, recently wrote up what he considers some of the worst SQL Server practices and offered recommended fixes. You can see the list here:...
View Answer
| Jul 25 2005 12:16 AM GMT
| asked by
nbellistri
Hardware, Database Management Systems, SQL Server
Upgrade to SQL Server 2005 sooner or later?
Hello,I'm the editor of SearchSQLServer.com and I am hoping to get your opinons on a timely topic.Prior to Microsoft announcing its November 7 release date for SQL Server 2005, we had run a poll asking site members: How have the delays with SQL Server 2005 affected your organization's plans?58%...
View Answer
| Jul 15 2005 10:19 AM GMT
| asked by
RobynLorusso23
Database Management Systems, SQL Server, Administration
Oracle Forms
Is there a way to use a Oracle Form to Upload a file to a specific folder and store the filename in the database? I know how to do this through HTML/ASP/VBS, but my company wants it through Oracle Forms.Also, how would I make a hidden field appear when a LOV Item is selected and when it appears...
View Answer
| Jul 7 2005 11:43 AM GMT
| asked by
WmFenn
Oracle, Tech support, Database Management Systems
IT Tech Assistant/No Admin Rights
I have hired a new IT support person, and I wanted to give him access to restart services ex: Print services, in my absense which occasionally needs resetting. Is their a way to give someone strict access to only restart services?
View Answer
| Jul 6 2005 2:52 PM GMT
| asked by
ESuazo
Security management, Auditing, Information risk management
Oracle Forms Developer/Builder for Oracle 9
I have two questions. The first is, how would you go about changing the applet size when running a form? Or, is there a way?The other question is, how can you use Forms Builder to upload a file/document to the database? I need to load a filepath but I'm not quite sure how I need to get the file...
View Answer
| Jul 5 2005 3:19 PM GMT
| asked by
WmFenn
Oracle, Database Management Systems, Development
What are the requirements for oracle10g Real Application clusters using ASM?
Dear sir,what are the software reqiurements for configuring Oracle 10g real application clusters?
View Answer
| Jul 5 2005 3:30 AM GMT
| asked by
eamathew
Oracle, Hardware, Database Management Systems
BOBJ Business Objects XI
We are considering implementing "BOBJ Business Objects XI" in our company. My question is can anyone offer a critique of the product. i.e. from a implementation & post imp point of view.Thanks in advance.
View Answer
| Jun 27 2005 7:04 AM GMT
| asked by
jellybean
DataCenter, Vendors, CIO
function to subtract 200 days from date
I need to write the filter condition in cognos as follows:YRMOSDOS between (&YRMOSDOS - 200) AND (&YRMOSDOS)where YRMOSDOS is in date form. How do I achieve it?The database is in db2. Decimal function does not work.Please help. Thanks a lot.
View Answer
| Jun 24 2005 11:20 AM GMT
| asked by
meenac
Database Management Systems, DB2, Data warehousing/Business intelligence
Number Crunching Machines
I just started at a new workplace and have been presented with a group of servers running software called Calcserve. I'm not entirely sure what they actually do but it is some sort of number crunching for various trust funds etc.What concerns me though is that I have worked on AS400's now for...
View Answer
| Jun 17 2005 8:05 AM GMT
| asked by
neilm1m
IT architecture, Hardware, Servers
Changing the statement heap parameter on iSeries
Hi,I would like to know how to change the statement heap parameter DB2 (stmtheap) on the AS/400. I tried the command GET DATABASE CONFIGURATION FOR database-alias (giving alias name as the AS/400 server name) but it returns the error "SQL0901N The SQL statement failed because of a non-severe...
View Answer
| Jun 8 2005 6:10 AM GMT
| asked by
sbkhole
DataCenter, Data center operations, Physical security
SQL Clustering
SQL Server 2000As far as performance tuning, where can I find statistics or could you offer your opinion in the following scenario. Which offers better performance, running One server in Active mode and another in inactive mode, each with four processors or Running both servers in active mode, each...
View Answer
| Jun 6 2005 3:33 PM GMT
| asked by
Krismop
Hardware, Servers, Database Management Systems
help me!!
hi!i m a beginner in java programing ... i need to create a database using java .... the data are in the form of tables .... plzz guide me how to do it or where can i get the help???? how shud i get started ??
View Answer
| May 30 2005 2:09 AM GMT
| asked by
beginner15
Hardware, Database Management Systems, CA Ingres
reusedlt *yes
Hi, Has reusedlt *yes behavior changed with V5R3?When I add a record to a PF that is reusedlt *yes in V5R2 is uses a record that has been deleted, however when i do the same thing on a V5R3 system it adds a new record rather than re-use one.Anyone run into this before?Thanks, Luis
View Answer
| May 23 2005 2:52 PM GMT
| asked by
xixones
Data center operations, Disaster Recovery, Security management
Spaces in Linux is getting Interpreted as ‘@’
Hi AllNeed some help.I use the BCP out command to transmit data from SQL Server database table and send it to flat files.The spaces (varchar datatype in table) gets transmitted as spaces only.When I use Linux command to get these files, out of 20,000 spaces , 1 space got interpreted as '@'.Can you...
View Answer
| May 16 2005 1:23 PM GMT
| asked by
bakash
Database Management Systems, SQL Server, Linux
Automatically Force User Disconnects via Scheduled Script
Greetings all ...What is the most efficient automated script-based approach to terminate user connections for "particular" databases?Where:1. Know name of database(s)2. Know name of user(s)3. Do not know name of user(s)4. Server must always remain in production and user(s) must not be...
View Answer
| May 16 2005 12:09 AM GMT
| asked by
ericggordon
Database Management Systems, SQL Server, Backup & recovery
Restoring a dtaq in iseries.
I need to know if there is a way to save a data queue with some entries in it, and then restore the data queue in the same or other library with its entries included.When i do that, the dtaq is empty.If someone knows how to do that, please tell me. Thanks.
View Answer
| May 12 2005 6:08 PM GMT
| asked by
Moreira
AS/400, Hardware, Database Management Systems
