ETL Informatica 32bit Vs 64bit
Is anyone using the 64bit version of Informatica? If so what kind of problems are you facing in the 64 bit version. Is there anything you like the most in the 64bit version? - Thanks in advance, bi_at_nj

SAP and ETL
In a SAP BW documentation I have came accross the following sentence and I don't understand the meaning: The extraction technology of SAP BW is supported by database management systems of mySAP technology and does not allow extraction from other

INFORMATICA FACT TABLES
Which table should be loaded first. Either Dimension table or fact table?

Where should the ETL be ?
As I understand in organisational IT architecture there are 3 tiers. 1st tier(Data storage layer) : All the databases . 2nd tier(Business Tier ): All the middleware applications that include ETLs, messaging middleware , object oriented middleware

Source for Accumulating Snapshot Fact table
I have a question about accumulating snapshots and I was hoping someone could shed some light on the subject. Does Kimball give any guidance anywhere (books, online, etc.) as to whether one should build the supporting transactional fact tables that

ETL from 250+ disparate customer host systems
My task is to produce an ETL process that pulls data daily from our customer systems (which can be most any database/OS). The data will be loaded into our central system, an analysis will be run and the aggregate data solution sent back to all customers.

ETL Replacement Suggestions Needed
Greetings, I’ve just begun the process of researching a fitting ETL tool that will allow for a simplistic user friendly source extraction to staging configuration for minimal licensing costs. We are in the works of decommissioning a very old version of

ETL Auditing standards and how to implement them.
Can any one share his/her experiences of what are the Industry standard ETL Auditing Standards you use and how you implelemt them. Any Tool specific examples will be appreciated: e.g Datastage and Informatica Thanks MJ

Database kdb ?
Is anyone using a database by name kdb ? If so, do u use informatica with it ? - Thanks, bi_at_nj

ETL for Accumulating Snapshot
I'm looking for a book, sql code, web links, anything to get me started on creating the ETL for an Accumulating Snapshot fact table. I've not yet been able to attend the Kimball ETL class (but the Dimensional Modeling class was great!). Does anyone

Hand coding ETL questions
I know the numerous pros of using an ETL tool, but due to circumstances outside my control I have to hand code the ETL. My questions are in regards to actual coding practices. I am currently loading a couple of dimensions using perl. So far the entire loa

ETL as a source for some attributes of a dimension
Hi all, is it allowed to programmatically add value on a row of a dimension by the etl process ? For instance : Source contains only books : NK | NAME 142 | invisible Etl source the DW dimension 'Product' and programmatically add a category :

Open source ETL vs commercial ETL
Anybody have experience with open source etl like Talend or Pentaho? They are becoming more popular, and I was wondering what advantages/ disadvantages of open source vs commercial etl tools. Any downsides of using open source for SOX or HIPAA?

ETL Architecture
Hi My company is currently planning on building a datawarehouse. We are an oracle shop and are considering the approach for data migration from client servers to the datamart. Thoughts we have 1) Asynchronous CDC . I believe oracle now is replacing

ETL approach for replacing multiple dates in one row.
We have a Fact table that stores several key dates in the life cycle of a customer. Each of these dates is supposed to be a surrogate key pointing to the date dimension. My questions pertains to efficiently replacing these dates with surrogate keys in the