title: Kettle Generic ETL Jobs
body: <p>I need to make a generic ETL for a the maintenance of an ODS.</p>
  
  <p>My requirements are:</p>
  
  <ol>
  <li>I have a table T with the names of the source tables and destination tables</li>
  <li>I need them to have the same data in different databases.</li>
  <li>The Kettle Job must to retreive from the source table T the list of tables to move and then move data from one to another.</li>
  </ol>
  
  <p>I've read that there is a transformation called <a href="http://wiki.pentaho.com/display/EAI/ETL+Metadata+Injection" rel="nofollow">Metadata Injection</a> for this purpose but I don't think I can do what I need with this transformation.</p>
  
  <p>Any ideas of how to do this? I think it's a common problem. I don't want to have hundreds of transformations for each table.</p>
  
  <p>Do you know a solution within Oracle?</p>
  
  <p>My Kettle version is 4.4.0 and my Oracle version is 11g</p>
  
  <p>Thank you very much in advance.</p>