Data Warehousing Applications

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 &...

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...

- 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?

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...

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

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,...

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...

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...

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...

ETL tool decision

Which ETL tool do you use and what were your reasons for choosing that tool over others on the market?