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
Answer Question
| September 15, 2009 2:35 PM
Data warehousing applications, Oracle, 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
Answer Question
| September 15, 2009 2:35 PM
Data warehousing applications, Oracle, 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 [...]
Answer Question
| April 12, 2009 7:44 PM
Data warehouses, Data warehousing applications, Microsoft Access, OLAP/OLTP
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 [...]
Answer Question
| April 12, 2009 7:44 PM
Data warehouses, Data warehousing applications, Microsoft Access, OLAP/OLTP
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?
Answer Question
| October 6, 2008 2:47 AM
Data warehouse, Data warehousing applications
I would like to know what kind of test should be performed to checkout the build and the test environment prior to testing?
Answer Question
| October 6, 2008 2:47 AM
Data warehouse, Data warehousing applications
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! Da Celt
Answer Question
| June 23, 2012 12:56 PM
Business Information Warehouse, Data management and storage, Data warehouses, Data warehousing applications, Database engineering, DataManagement
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! Da Celt
Answer Question
| June 23, 2012 12:56 PM
Business Information Warehouse, Data management and storage, Data warehouses, Data warehousing applications, Database engineering, DataManagement
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 about different years growth statistics [...]
Answer Question
| July 31, 2008 5:33 PM
Data analysis, Data Junction, Data management and storage, Data warehousing applications, Database design, Database issues
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 about different years growth statistics [...]
Answer Question
| July 31, 2008 5:33 PM
Data analysis, Data Junction, Data management and storage, Data warehousing applications, Database design, Database issues
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).
Answer Question
| June 12, 2008 2:14 PM
Data warehousing applications, Data/Application Integration, Database, SQL Server 2005, 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).
Answer Question
| June 12, 2008 2:14 PM
Data warehousing applications, Data/Application Integration, Database, SQL Server 2005, SSAS 2000
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? Please forward on [...]
Answer Question
| March 10, 2008 3:58 PM
Application development, Business Objects, Business/IT alignment, C, Career development, Certifications, Cognos, Computer Associates, Crystal Reports, Data Junction, Data mining/analysis, Data warehousing applications, Database, DB2, Deltek Systems, Desktops, Development, Distribution/logistics applications, Enterprise Desktop, Financial services applications, IBM, Linux, Management, Microsoft Windows, MySQL, Oracle, OS, PeopleSoft, SAP, SAS Institute, Security, Servers, Software Quality Assurance, Software testing, SPSS, SQL, SQL Server, SS&C Technologies, SunGard Data Systems, Systems Union Group, Training, Transaction Systems Architects, VBScript, Vendors, Visual Basic, Web development, Web development tools
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? Please forward on [...]
Answer Question
| March 10, 2008 3:58 PM
Application development, Business Objects, Business/IT alignment, C, Career development, Certifications, Cognos, Computer Associates, Crystal Reports, Data Junction, Data mining/analysis, Data warehousing applications, Database, DB2, Deltek Systems, Desktops, Development, Distribution/logistics applications, Enterprise Desktop, Financial services applications, IBM, Linux, Management, Microsoft Windows, MySQL, Oracle, OS, PeopleSoft, SAP, SAS Institute, Security, Servers, Software Quality Assurance, Software testing, SPSS, SQL, SQL Server, SS&C Technologies, SunGard Data Systems, Systems Union Group, Training, Transaction Systems Architects, VBScript, Vendors, Visual Basic, Web development, Web development tools
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 effcient way of getting [...]
Answer Question
| May 15, 2008 6:54 AM
Data analysis, Data warehousing applications, Database, DB2, DB2 Universal Database, Development, Oracle, PC/Windows Connectivity, SQL
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 effcient way of getting [...]
Answer Question
| May 15, 2008 6:54 AM
Data analysis, Data warehousing applications, Database, DB2, DB2 Universal Database, Development, Oracle, PC/Windows Connectivity, SQL
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. Pls let me know is there a [...]
Answer Question
| December 18, 2006 4:17 AM
Brightmail, CipherTrust, ClearSwift, Data warehousing applications, E-business, Ecommerce applications, Exchange, Exchange security, McAfee, MessageLabs, Microsoft Windows, Postini, Rockliffe, Spam, SpamAssassin, SurfControl, Symantec, TrendMicro
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. Pls let me know is there a [...]
Answer Question
| December 18, 2006 4:17 AM
Brightmail, CipherTrust, ClearSwift, Data warehousing applications, E-business, Ecommerce applications, Exchange, Exchange security, McAfee, MessageLabs, Microsoft Windows, Postini, Rockliffe, Spam, SpamAssassin, SurfControl, Symantec, TrendMicro
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?
Answer Question
| November 13, 2006 12:53 AM
Access, Application development, Backup & recovery, CLP, Data analysis, Data mining/analysis, Data warehousing applications, Database, DataCenter, DB2, DB2 Universal Database, Desktops, Email, IBM Marketing Sound Off, Management, Microsoft Office, Microsoft Windows, Oracle, OS, Patch management, PC/Windows Connectivity, Printing, RPG, RPGLE, Security, Servers, SQL, SQL Server, Web development
Hi All, Can we connect remotely (from outside LAN) to a MS SQL server 2000 using enterprise manager? If so, what are the steps?
Answer Question
| November 13, 2006 12:53 AM
Access, Application development, Backup & recovery, CLP, Data analysis, Data mining/analysis, Data warehousing applications, Database, DataCenter, DB2, DB2 Universal Database, Desktops, Email, IBM Marketing Sound Off, Management, Microsoft Office, Microsoft Windows, Oracle, OS, Patch management, PC/Windows Connectivity, Printing, RPG, RPGLE, Security, Servers, SQL, SQL Server, Web development
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 an end [...]
Answer Question
| August 29, 2006 1:10 AM
Data mining/analysis, Data warehousing applications
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 an end [...]
Answer Question
| August 29, 2006 1:10 AM
Data mining/analysis, Data warehousing applications
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 approach is to have a SINGLE dim called PERSON given all 3 [...]
Answer Question
| July 27, 2006 10:45 AM
Data warehousing applications
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 approach is to have a SINGLE dim called PERSON given all 3 [...]
Answer Question
| July 27, 2006 10:45 AM
Data warehousing applications
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 [...]
Answer Question
| June 30, 2006 11:35 AM
Data warehousing applications, Microsoft Windows, SQL Server
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 [...]
Answer Question
| June 30, 2006 11:35 AM
Data warehousing applications, Microsoft Windows, SQL Server
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 showed me [...]
Answer Question
| June 29, 2006 7:29 AM
Backup & recovery, Cabling, Data analysis, Data mining/analysis, Data warehousing applications, Database, DataCenter, DataManagement, DB2, Desktop management applications, Desktops, DHCP, DNS, Ecommerce applications, Enterprise Desktop, Exchange, Hardware, Hewlett-Packard, Hubs, Instant Messaging, Lotus Domino, Management, Microsoft Systems Management Server, Microsoft Windows, Network management software, Networking, Networking services, Oracle, OS, PC/Windows Connectivity, Power management, Routers, Security, Servers, Software, SQL Server, Switches, Systems management software, Tech support, Training
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 showed me [...]
Answer Question
| June 29, 2006 7:29 AM
Backup & recovery, Cabling, Data analysis, Data mining/analysis, Data warehousing applications, Database, DataCenter, DataManagement, DB2, Desktop management applications, Desktops, DHCP, DNS, Ecommerce applications, Enterprise Desktop, Exchange, Hardware, Hewlett-Packard, Hubs, Instant Messaging, Lotus Domino, Management, Microsoft Systems Management Server, Microsoft Windows, Network management software, Networking, Networking services, Oracle, OS, PC/Windows Connectivity, Power management, Routers, Security, Servers, Software, SQL Server, Switches, Systems management software, Tech support, Training
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 automatic totals in OLAPI sums [...]
Answer Question
| July 5, 2006 1:01 PM
Business Objects, Data warehousing applications, Microsoft Windows
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 automatic totals in OLAPI sums [...]
Answer Question
| July 5, 2006 1:01 PM
Business Objects, Data warehousing applications, Microsoft Windows
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 [...]
Answer Question
| June 6, 2006 2:26 PM
Data warehousing applications, DataCenter, Development, Microsoft Windows, Network applications management, Network management software, Network protocols, Network testing, Networking, Performance management, Protocol analysis, standards, TCP
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 [...]
Answer Question
| June 6, 2006 2:26 PM
Data warehousing applications, DataCenter, Development, Microsoft Windows, Network applications management, Network management software, Network protocols, Network testing, Networking, Performance management, Protocol analysis, standards, TCP
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’ SELECT DISTINCT fld_cust_id INTO #custA FROM tbl_cust_ld WHERE fld_ld_status = ‘active’ and fld_cust_id in [...]
Answer Question
| June 11, 2011 6:08 PM
Certifications, Crystal Reports, Data warehousing applications, Development, Project management
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’ SELECT DISTINCT fld_cust_id INTO #custA FROM tbl_cust_ld WHERE fld_ld_status = ‘active’ and fld_cust_id in [...]
Answer Question
| June 11, 2011 6:08 PM
Certifications, Crystal Reports, Data warehousing applications, Development, Project management
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 marquee. It doesn’t really matter [...]
Answer Question
| March 18, 2006 2:48 PM
Billing and customer care, Billing Support Systems, Call Centers, Career development, CRM, Data analysis, Data mining/analysis, Data warehousing applications, Database, DataCenter, DataManagement, DB2, Desktop management applications, Desktops, Development, E-business, Hardware, IBM, Lifecycle development, Management, Microsoft Windows, NCR, Networking, Oracle, OS, Project management, Sales force automation applications, Security, Servers, Software, Software Quality Assurance, SQL Server, Storage, Tech support, Web services, Web Services Standards
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 marquee. It doesn’t really matter [...]
Answer Question
| March 18, 2006 2:48 PM
Billing and customer care, Billing Support Systems, Call Centers, Career development, CRM, Data analysis, Data mining/analysis, Data warehousing applications, Database, DataCenter, DataManagement, DB2, Desktop management applications, Desktops, Development, E-business, Hardware, IBM, Lifecycle development, Management, Microsoft Windows, NCR, Networking, Oracle, OS, Project management, Sales force automation applications, Security, Servers, Software, Software Quality Assurance, SQL Server, Storage, Tech support, Web services, Web Services Standards
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 additional software/hardware. 2. We are [...]
Answer Question
| August 4, 2011 11:14 AM
Billing and customer care, Billing Support Systems, Content management applications, Corporate portal applications, Data analysis, Data mining/analysis, Data warehousing applications, DataCenter, Desktop management applications, Desktops, Development, E-business, Ecommerce applications, Exchange, Financial services applications, Help Desk, Information Builders, Instant Messaging, Management, Microsoft Office, Microsoft Windows, Network applications management, Network management software, Networking, OS, Project management, Remote management, Security, Servers, SQL Server, Web services, Web site design & management
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 additional software/hardware. 2. We are [...]
Answer Question
| August 4, 2011 11:14 AM
Billing and customer care, Billing Support Systems, Content management applications, Corporate portal applications, Data analysis, Data mining/analysis, Data warehousing applications, DataCenter, Desktop management applications, Desktops, Development, E-business, Ecommerce applications, Exchange, Financial services applications, Help Desk, Information Builders, Instant Messaging, Management, Microsoft Office, Microsoft Windows, Network applications management, Network management software, Networking, OS, Project management, Remote management, Security, Servers, SQL Server, Web services, Web site design & management
Relation Between virtual memory, cache memory and RAM?
Hi friends, Hope you all are doing fine. Actually, I am new in the networking field. Can anybody tell me the size relation between virtual, cache and RAM memory in Windows Operating systems? Thanks in advance.
Answer Question
| April 19, 2013 4:03 AM
Cabling, Data analysis, Data Junction, Data mining/analysis, Data warehousing applications, DataCenter, Hardware, Hubs, Microprocessors, Microsoft Windows, Networking, Routers, Switches, Systems management software
Hi friends, Hope you all are doing fine. Actually, I am new in the networking field. Can anybody tell me the size relation between virtual, cache and RAM memory in Windows Operating systems? Thanks in advance.
Answer Question
| April 19, 2013 4:03 AM
Cabling, Data analysis, Data Junction, Data mining/analysis, Data warehousing applications, DataCenter, Hardware, Hubs, Microprocessors, Microsoft Windows, Networking, Routers, Switches, Systems management software
