Results 1 for
"cost of an etl tool"
Hand-Coded ETL revisited
Hi I read Gary Nissen's article, 'Is Hand-Coded ETL the Way to Go?', with interest. Given that this was written nearly six years ago, I wonder whether the position has changed i.e. whather ETL tools are now more strongly recommended ober
Hi I read Gary Nissen's article, 'Is Hand-Coded ETL the Way to Go?', with interest. Given that this was written nearly six years ago, I wonder whether the position has changed i.e. whather ETL tools are now more strongly recommended ober
ETL Replacement Suggestions Needed
Greetings, Ive 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
Greetings, Ive 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
How to consolidate numerous ETL processes?
Hi, Within the department there are numerous users whose ETL processes are slightly identical to one another (e.g. an extra variable). This not only puts a burden on the server load, but also create problems where a certain measure is not identical
Hi, Within the department there are numerous users whose ETL processes are slightly identical to one another (e.g. an extra variable). This not only puts a burden on the server load, but also create problems where a certain measure is not identical
Flat File Importing via SSIS - Best approach?
My company is frequently faced with the need to import and profile flat files submitted by various prospects and customers. These customers rarely provide us with a format file and when they do it is rarely accurate. Importing CSV files is slightly easier
My company is frequently faced with the need to import and profile flat files submitted by various prospects and customers. These customers rarely provide us with a format file and when they do it is rarely accurate. Importing CSV files is slightly easier
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
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
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.
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.
Cost plans for projects - One fact table or several fact tables?
Hi, I'm currently struggling with my Dimensional Model. It is about projects with their related cost plans. Every project starts with an initial cost plan (called WIPL), the project is saved as version 0 and the WIPL attribute and the ACTUAL attribute i
Hi, I'm currently struggling with my Dimensional Model. It is about projects with their related cost plans. Every project starts with an initial cost plan (called WIPL), the project is saved as version 0 and the WIPL attribute and the ACTUAL attribute i
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
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
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
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
Need for a dimensional modeling tool?
I'd like to hear opinions from members of this group about the need for a modeling tool that's more oriented towards dimensional models. Most of us use Erwin or a similar modeling tool, which is designed for general E/R modeling (to be honest, Erwin also
I'd like to hear opinions from members of this group about the need for a modeling tool that's more oriented towards dimensional models. Most of us use Erwin or a similar modeling tool, which is designed for general E/R modeling (to be honest, Erwin also
System Tool 2011 help
HI, Can anyone on help. My Dad's PC is infected and i am unable to access the internet from his PC. I have come home to try and get some help. I cannot download malware as I cannot open his vodafone dongle to connect it. I have trien in safe mode also. I
HI, Can anyone on help. My Dad's PC is infected and i am unable to access the internet from his PC. I have come home to try and get some help. I cannot download malware as I cannot open his vodafone dongle to connect it. I have trien in safe mode also. I
Gmod Server Tool List
Here is the list of tools that we have so far, Feel free to petition new tools: Wiremod GCombat Door Tool Smart Weld Adv. Duplicator Weight Tool ULX PHX 3
Here is the list of tools that we have so far, Feel free to petition new tools: Wiremod GCombat Door Tool Smart Weld Adv. Duplicator Weight Tool ULX PHX 3
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
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 :
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?
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?
Results 1 to 15 on 150
for "cost of an etl tool"
for "cost of an etl tool"
Active topics
Popular topics
Unanswered topics
