Data Warehousing Applications

Oracle Workflow under Vista

When Oracle will provide Workflow Manager on Vista platform. I am coming from Data warehouse area, and workflow palys a main role in process flow management. Mehdi Software/Hardware used: Vista

front end tools

My company is in the process of building out a DW. Although there has been many discussion topics within the individual end users, the one area of conflict is on what front end tool to use. More specifically, we have some expert users who want to directly access the DW and others who are ok with...

how to smoke test the data warehouse?

I would like to know what kind of test should be performed to checkout the build and the test environment prior to testing?

Does anyone have an MS Project file for a DW implementation they'd be willing to share?

Greetings all, As my orgaization begins the planning phase of a data warehouse implementation, I'd imagine it would be a true benefit to have a roadmap of an actual DW implementation in order to make certain all areas are addressed. Does anyone have a complete DW in MS Project form? Many thanks!...

Database Question.

Hello all .. I am doing an Internship with a company in Nashville that does community branding. Recently I received a project to design a database which would house all of the information that we would need to show to potential clients to gain their business. Such as particular information...

Data Sources for SSAS 2000

I have a short term issue where I will need a SSAS2000 cube to be using data from a SQLServer2005 database. Can I do this directly? If not, can I Export MSSS2005 data directly to the MSSS2000 database? (Sorry for such a simple question- I am a newbie).

C#.Net

Does anyone know of a good place to find people with C#.net experience besides the big job boards? We have several positions in the Financial/Trading industry in Chicago but we are having a hard time finding enough people with this skill set. Any Blogs, User Groups or Niche Sites you can recommend?...

Select last 3 transactions

Hello Can someone help me to put together an SQL statement to select the last 3 transactions from a transaction file. In TransactSQL I would do something like this: select top 3 CustID, TransDate, Amount from Trans where CustID= '12345' order by TransDate desc. I believe there must be a more...

Exchange Server Messaging Solution

My requirement I need to log (Including mail content) the mail communications between certain group of users in the same Exchange server. Logging should be done in the central repository like SQL Server so that my application can be used to view the mail communications between the groups....

MS SQL Server 2000

Hi All, Can we connect remotely (from outside LAN) to a MS SQL server 2000 using enterprise manager? If so, what are the steps?

Data Warehouse - 'thin layer' or snapshots?

We are re-designing a data warehouse and need to decide whether we create a solution that is snapshot based (i.e. a full copy of every customer and their attributes each month) or one that is more transaction based (i.e. a full copy of all customers, then every time their attributes change, we put...

Dimensions - COMBINATION or SEPERATION

I recognize 3 areas of interest to my customer: * Dealership Customers (aka Clients). People who bring their cars to dealerships. * Dealership Employees. Service Advisors who make service recommendations. * CompanyX Employees. Account Mgrs who sell the Product to the Dealerships. 1...

SQL Server Integration Services - Pivot Transformation

I'm trying to transform; fld1 fld2 fld3 fld4 value A B C 2 100 A B C 3 250 A B C 4 400 to; fld1 fld2 fld3 feb mar apr A B C 100 250 400 but I'm getting; fld1 fld2 fld3 feb mar apr A B C 100 NULL NULL A B C NULL 250 NULL A B ...

Can't login as Administrator

Hello Everybody, I can't login to adminstrator profile in my standalone win 2000 adv server. I use this system for my study purposes. What happened actually is when I was shuting my system, it got powered off because of some UPS problem and the next time when I logged in using Administrator, it...

BOBJ OLAPI TOTALS PROBLEM

Hi All, Am facing a problem on Totalling on Business Objects OLAPI. Automatic totals? is the ability to add a total to the rows or to the columns of your report. Additionally when drilling down, OLAPI keeps the parent in the column of information. This results in double counting because...

Unable to detect a parity error with Windows SDK on a PCI serial card

We are using a 9-bit protocol which sometimes sends a mark state and sometimes sends a space stage. When a space state is sent we want to be able to get a parity error in SDK. We can see the parity error in the hardware register but we want to be able to see the error with Windows SDK software. ...

Crystal Reports

I am working on a report in Crystal Report, I have a stored Procedure like this ALTER PROCEDURE [dbo].[usp_cust_by_activity] @carrier as VARCHAR(10) AS --drop table #custA --drop table #custPA --drop table #cdrall --drop table #cdrPrevMonth --SET @carrier = 'PR' --'PR', 'RG'...

Capture screen w/scrolling marquee

My company uses a 3rd party software. There's one screen that has a few graphs and a few lines that scroll across the screen. Similiar to a Screen Saver's Scrolling Marquee. They redesigned the software and this screen will no longer exist. I would like to capture this screen w/scrolling...

Posting Data Online

We want to "post" various documents on-line so that we can give members of our outside consulting group access to view, and even possibly download them. Is it possible without opening them up to the public-at-large? In answering, keep in mind the following: 1. We prefer not to purchase any...

Relation Between Virtual Memory, Cache Memory and RAM???

Hiii Friends, Hope so all are doin fine. Actually i am new in the networking field, can anybody tell the size relation between Virtual, Cache and RAM Memory in Windows Operating systems Thanks in Advance..