DATABASES TECHNIQUES
You need to google for STAR Schemas and Snowflake Schemas.

View Answer   |  May 19, 2010  5:09 AM
Database Management Systems, Database schema, Relational databases

Network Admin code of ethics?
I think this website (<a href=”http://lopsa.org/CodeOfEthics”>League of Professional Systems Administrators</a>) has the answer your superintendent is looking for. You could use this document as you wish as an agreement between you and the organization and/or users.

View Answer   |  May 18, 2010  7:34 PM
Network Administrator, Networking, privacy, Privacy Protection

IT project management task list
Which methodology are you following? There are many sites on the web that give generic basic project methodology documents and templates. Can you give more details on the projects?

View Answer   |  May 18, 2010  3:38 PM
IT project management, Project management templates

Is an existing BI solution required to use the BI capabilities of SQL Server R2?
No existing BI solutions are required for using the BI capabilities of SQL Server 2008 R2. You can build new BI solutions using SQL Server 2008 R2. With SQL Server 2008 R2 we are simply adding more functionality by expanding our offering toe more extensively cover the areas of self service BI. So with SQL [...]

View Answer   |  May 12, 2010  1:42 AM
Business Intelligence, SQL Server 2008 R2, SQL Server 2008 R2 Features

Managed Self Service Approach to BI
Managed self service BI can benefit your organization in multiple ways: First of all it will allow more users to do BI due to ease of use of the tools. Secondly it will allow your organization build and manage BI solutions more efficiently. Why? By allowing the business users with the domain expertise to serve [...]

View Answer   |  May 10, 2010  8:14 PM
Business Intelligence, SQL Server 2008 R2

Help with Data Quality
Microsoft recognizes Data Quality and authoritative data management as key components of an enterprise information management strategy. With the acquisition of Zoomix, Microsoft is actively pursuing a data quality strategy that will integrate across Integration Services, Master Data Services, and the recently announced project Dallas – an authoritative public data store in the cloud, compatible [...]

View Answer   |  May 5, 2010  8:16 PM
Data quality, Data quality tools, SQL Server 2008 R2, SQL Server Data Quality

DB2 Table Size in V6R1
Hello, Very informative website for this information… http://www.mcpressonline.com/database/db2/v6r1-db2-for-i5/os-highlights.html Hope it helps… ============================================================= Database capacities haven’t changed significantly (if at all) between V5R4 and V6.1. See <a href=”http://publib.boulder.ibm.com/infocenter/iseries/v6r1m0/index.jsp?topic=/dbp/rbafoappmax.htm”>V6.1 database maximum capacities</a>. Also, note that a SQL “TABLE” can only have a single member. However, maximum capacity is given for <i>member size, not file size</i>. And a [...]

View Answer   |  May 5, 2010  7:47 AM
DB2, V6R1

database management system
Benefits of Database Management Database management systems are programs that are written to store, update, and retrieve information from a database. There are many databases available in the market. The most popular are the Oracle and SQL Server. The Oracle database is from the Oracle Corporation and the SQL Server is from the Microsoft Corporation. [...]

View Answer   |  May 5, 2010  5:03 AM
Database Management Systems

COBOL date reformatting
01 DATE-IN-9 PIC 9(009). 01 DATE-WORK REDEFINES DATE-IN-9. 05 FILLER PIC X(001). 05 DW-CCYY PIC 9(004). 05 DW-MONTH PIC 9(002). 05 DW-DAY PIC 9(002). 01 DATE-OUT. 05 DO-DAY PIC X(002). 05 FILLER PIC X(001) VALUE “-”. 05 DO-MONTH PIC X(003). 05 FILLER PIC X(001) VALUE “-”. 05 DO-CCYY PIC X(004). 01 MONTH-TABLE. 05 FILLER PIC [...]

View Answer   |  May 5, 2010  1:35 AM
COBOL, DB2, DOC1

How to learn DB2?
IBM has a free DB2 for just this sort of thing – it is called DB2 Express. Check the IBM web site WWW.IBM.COM and search within it for DB2 Express. Depending on what you want to learn about DB2, this may or may not be what you are after. A product will only go so [...]

View Answer   |  May 4, 2010  7:57 PM
DB2, DB2 administration, DB2 certification

Integrate ERP with SQL Server 2008 R2
We are actively working with our partners and ISVs to enable applications to use SQL Azure. If you have any specific applications that you are interested in please send an email to tonypet@microsoft.com and we will investigate the possibilities.

View Answer   |  May 3, 2010  9:43 PM
ERP, SQL Azure, SQL Server 2008 R2

DB2 data over web browser
<a href=”http://blogs.systeminetwork.com/isnblogs/productlines/2008/08/getting_a_grip_on_app_moderniz.html”>http://blogs.systeminetwork.com/isnblogs/productlines/2008/08/getting_a_grip_on_app_moderniz.html</a>

View Answer   |  May 3, 2010  7:15 PM
AS/400 DB2, DB2, System i

Data entry and calculations in the same cell
Some VBA code like this should work: <pre>Private Sub Worksheet_Change(ByVal Target As Range) Dim newValue As Double Dim newCell As Range If Target.Row < 3 Then If Target.Row = 1 Then Set newCell = Cells(2, Target.Column) newValue = Target.Value / 2.205 ElseIf Target.Row = 2 Then Set newCell = Cells(1, Target.Column) newValue = Target.Value * [...]

View Answer   |  April 29, 2010  7:14 PM
Data conversion, excel, Excel Cell Formatting, Excel formulas

Importing files to as400
A .CSV file makes sense in a directory under the /root file system. If your user profile name is CKW, you might, for example, have an assigned home directory named /home/CKW. Uploading into that directory would be a reasonable thing to do. You might use FTP to connect, change your target directory to /home/CKW, and [...]

View Answer   |  April 28, 2010  9:57 PM
AS/400, as400 data import, CSV file format, CSV to AS400

file transfer from mainframe to Desktop/PC using IEBCOPY
IEBCOPY is not going to write to a PC file. Nor is IEB-anything going to read or write to a PC file. Well, it might be able to write to a USS file, but that is not the same and I don’t work with USS. ( USS = UNIX System Services.) Your z/OS dataset is [...]

View Answer   |  April 28, 2010  2:17 PM
Desktops, File transfers, IEBCOPY, Mainframe, mainframe to PC

Value cannot be null.Parameter name:path1
The message is pretty explanatory. Your report has a paramter ‘path1′ which cannot be null, and in this case it is. If you are calling your report from another application, review the code of that application to see why it is sending a null value for that parameter. To debug it, you could display a [...]

View Answer   |  April 28, 2010  2:05 PM
Crystal Reports, VB.NET 2005

How to create a text file in i5/OS system
Jacky, Could you describe a little more what you are wanting to accomplish? Do you want to create a file from another system? Or do you want to be able to create a file by keying it in? Stuart ========================================================== If you want to create text files like you do with Notepad, then use Notepad. [...]

View Answer   |  April 27, 2010  7:23 AM
File formats, i5, OS/400

RRN Max
Hi, Is this on an AS/400? If so which version of the OS are you using? We have V5R4 and that seems to allow 2.1 billion records (2,147,483,646). Regards, Martin Gilbert. =============================================================== For V5R4 — “Number of records contained in a file member – 4 294 967 294 records”. See <a href=”http://publib.boulder.ibm.com/infocenter/iseries/v5r4/index.jsp?topic=/dbp/rbafoappmax.htm”>Database file sizes</a>. But [...]

View Answer   |  April 27, 2010  6:51 AM
DB2, DB2 capacity, RRN

Crystal Report Combine field
I guess Crystal Reports doesn’t provide a way to do that, but you can certainly base your report on a query that gets the information in that way. It is going to be an ugly query, and if you need to do something like that maybe you need to revise your database design.

View Answer   |  April 23, 2010  12:33 AM
Crystal Reports, Crystal Reports 9, Crystal Rpeorts Combine Field

UC520 vs. Avaya IP Office 500
Are you still looking for a comparison of each system’s features? If so, I have some great literature on both.

View Answer   |  April 22, 2010  3:56 PM
Avaya, Avaya IP Agent, Avaya IP Office 500, Cisco UC520, UC500, UC520, Unified Communications, Unified Communications Hardware