Conversion of de-duplicated Customer Numbers due to source system change
We have a Data Warehouse which de-duplicates Customers from 3 operational systems to enable more accurate customer reporting, data mining & CRM activities. We have several month-end snapshots history. Our organisation is building a new Operation Data Store which will now take over the de-dupe & key persistency functions. The ODS uses more up to [...]
Answer Question
| May 18, 2005 2:03 AM
CRM, Customer relationship management applications, Data warehousing applications, IBM, Oracle
We have a Data Warehouse which de-duplicates Customers from 3 operational systems to enable more accurate customer reporting, data mining & CRM activities. We have several month-end snapshots history. Our organisation is building a new Operation Data Store which will now take over the de-dupe & key persistency functions. The ODS uses more up to [...]
Answer Question
| May 18, 2005 2:03 AM
CRM, Customer relationship management applications, Data warehousing applications, IBM, Oracle
Transfer Report from AS/400 to PC
Is there any utilities/tools that can help me to create a program on AS/400 (CL program) to transfer the reports that are created at a certain output queue on AS/400, transfer them automatically to a specific folder at PC side so as to be opened with any application at MS Windows, keeping the Layout(View) of [...]
Answer Question
| October 24, 2010 10:30 AM
AS/400, Call Centers, Data analysis, Data mining/analysis, Data warehousing applications, Database Management Systems, DataCenter, Development, ERP, Exchange, Hardware, Help Desk, IBM, Knowledge management applications, Lifecycle development, Servers, Software, Tech support, Third-party services, Vendor support
Is there any utilities/tools that can help me to create a program on AS/400 (CL program) to transfer the reports that are created at a certain output queue on AS/400, transfer them automatically to a specific folder at PC side so as to be opened with any application at MS Windows, keeping the Layout(View) of [...]
Answer Question
| October 24, 2010 10:30 AM
AS/400, Call Centers, Data analysis, Data mining/analysis, Data warehousing applications, Database Management Systems, DataCenter, Development, ERP, Exchange, Hardware, Help Desk, IBM, Knowledge management applications, Lifecycle development, Servers, Software, Tech support, Third-party services, Vendor support
- DB2 – RPG
My question has two parts: 1- Is there any way to create DB2 at a PC similar to what is exist at IBM I-Series AS/400? 2- Is there any RPG Compiler that I can install and run it and PC?
Answer Question
| April 14, 2005 9:15 AM
Business Objects, CA Ingres, Cognos, Data analysis, Data Junction, Data mining/analysis, Data warehousing applications, Database Management Systems, Development, Hardware, IBM, Information Builders, Instant Messaging, Microsoft Access, Microsoft Windows, MySQL, Servers, Software
My question has two parts: 1- Is there any way to create DB2 at a PC similar to what is exist at IBM I-Series AS/400? 2- Is there any RPG Compiler that I can install and run it and PC?
Answer Question
| April 14, 2005 9:15 AM
Business Objects, CA Ingres, Cognos, Data analysis, Data Junction, Data mining/analysis, Data warehousing applications, Database Management Systems, Development, Hardware, IBM, Information Builders, Instant Messaging, Microsoft Access, Microsoft Windows, MySQL, Servers, Software
Data Architect career path
I currently work as a data analyst creating reports within an access environment, and in addition have Oracle SQL and Business objects reporting skills. However I am keen to change my career path towards becoming a data architect, and would like to know what training courses to take in order to achieve this. I would [...]
Answer Question
| March 1, 2005 4:02 PM
Data analysis, Data warehousing applications, DataCenter, ERP, Microsoft Windows, Oracle
I currently work as a data analyst creating reports within an access environment, and in addition have Oracle SQL and Business objects reporting skills. However I am keen to change my career path towards becoming a data architect, and would like to know what training courses to take in order to achieve this. I would [...]
Answer Question
| March 1, 2005 4:02 PM
Data analysis, Data warehousing applications, DataCenter, ERP, Microsoft Windows, Oracle
MS ACCESS: Creating a field with AutoNumbers as a datatype
In MS Access when I create a “Make-Table Query” or any query, how do I add a new field of some name that has an Datatype of Autonumbers? Can this be done without making a Module or using VB coding? Hope you can help. Thanks
Answer Question
| December 2, 2004 9:53 AM
Data mining/analysis, Data warehousing applications, Microsoft Windows
In MS Access when I create a “Make-Table Query” or any query, how do I add a new field of some name that has an Datatype of Autonumbers? Can this be done without making a Module or using VB coding? Hope you can help. Thanks
Answer Question
| December 2, 2004 9:53 AM
Data mining/analysis, Data warehousing applications, Microsoft Windows
Datawarehouse building – datamart specification: how would you engage a scattered userbase?
We are currently building a datawarehouse and will need to engage the customers in order to successfully specify the datamarts, a search functionality, etc. All of the technicalities are scoped and being put in place. The question hence directs itself to successfully engaging the customer base, without whose input this could never be successful. Some [...]
Answer Question
| October 12, 2004 10:43 AM
Data analysis, Data warehousing applications, DataCenter, ERP, Financial services applications, Implementation, Information risk management, Knowledge management applications, Remote users, Transaction Systems Architects
We are currently building a datawarehouse and will need to engage the customers in order to successfully specify the datamarts, a search functionality, etc. All of the technicalities are scoped and being put in place. The question hence directs itself to successfully engaging the customer base, without whose input this could never be successful. Some [...]
Answer Question
| October 12, 2004 10:43 AM
Data analysis, Data warehousing applications, DataCenter, ERP, Financial services applications, Implementation, Information risk management, Knowledge management applications, Remote users, Transaction Systems Architects
Openings for experienced consultants-2
I am conducting searches for consultants in ERP Financial, Distribution, Pharma, Travel/Entertainment, Transportation industries, CRM, SAP, Oracle, PeopleSoft, analysts, business developers, architects, data warehousing and data mining consultants. Can be based anywhere in the US. Please contact me for more info. thank you Laurie
Answer Question
| August 21, 2004 7:14 PM
Data analysis, Data warehousing applications, ERP, Microsoft Windows
I am conducting searches for consultants in ERP Financial, Distribution, Pharma, Travel/Entertainment, Transportation industries, CRM, SAP, Oracle, PeopleSoft, analysts, business developers, architects, data warehousing and data mining consultants. Can be based anywhere in the US. Please contact me for more info. thank you Laurie
Answer Question
| August 21, 2004 7:14 PM
Data analysis, Data warehousing applications, ERP, Microsoft Windows
Openings for experienced consultants
I am conducting searches for consultants in ERP Financial, Distribution, Pharma, Travel/Entertainment, Transportation industries, CRM, Oracle, PeopleSoft, analysts, business developers, architects, data warehousing and data mining consultants. Can be based anywhere in the US. Please contact me for more info. thank you Laurie
Answer Question
| August 18, 2004 7:13 PM
Data analysis, Data warehousing applications, ERP, Microsoft Windows
I am conducting searches for consultants in ERP Financial, Distribution, Pharma, Travel/Entertainment, Transportation industries, CRM, Oracle, PeopleSoft, analysts, business developers, architects, data warehousing and data mining consultants. Can be based anywhere in the US. Please contact me for more info. thank you Laurie
Answer Question
| August 18, 2004 7:13 PM
Data analysis, Data warehousing applications, ERP, Microsoft Windows
data warehousing and dimensional modelling
is there any way to conclude if any particular schema (star,snow flake or any other) is most suitable for an industry type (pharma,manufacturing,retail, etc) irrespective of the paltform on which the data warehouse will be developed. Is there any book which dicusses this in depth or some online material which can further help. Thanks all
Answer Question
| July 19, 2004 5:46 PM
Business Objects, Cognos, Customer relationship management applications, Data analysis, Data mining/analysis, Data warehousing applications, Database Management Systems, Development, Ecommerce applications, ERP, Hardware, Informatica, Lifecycle development, Software Quality Assurance
is there any way to conclude if any particular schema (star,snow flake or any other) is most suitable for an industry type (pharma,manufacturing,retail, etc) irrespective of the paltform on which the data warehouse will be developed. Is there any book which dicusses this in depth or some online material which can further help. Thanks all
Answer Question
| July 19, 2004 5:46 PM
Business Objects, Cognos, Customer relationship management applications, Data analysis, Data mining/analysis, Data warehousing applications, Database Management Systems, Development, Ecommerce applications, ERP, Hardware, Informatica, Lifecycle development, Software Quality Assurance
ETL tool decision
Which ETL tool do you use and what were your reasons for choosing that tool over others on the market?
Answer Question
| May 14, 2004 11:43 AM
Data warehousing applications
Which ETL tool do you use and what were your reasons for choosing that tool over others on the market?
Answer Question
| May 14, 2004 11:43 AM
Data warehousing applications
