Title: How to pass source table name and target table name from text file in pentaho ETL
Tags: pentaho;transformation;kettle
Question: I am begineer in Pentaho Data intregation..
In my transformation their is one table input (source) and one table output (target) and the data is copying from source to target.
What I want is that the table input step  fetches the tablename(source table which is in database) from some text file and loads the data to table output(target).the name of target table (whose structure is in database) is also to be fetch from text file...
If you need any details,which i missed to mention, please let me know.
Comment: Text file is simply a notepad file containing names of source tables line by lines...Yes for now the tables are in same schema...

Comment: Yes all the tables are in same schema

Comment: No,source tables have diferent structure..

Comment: What is the structure of the text file? Also, do these tables all have the same schema? If not, you may have to use `ETL Metadata Injection`.

Comment: What about the table schemas? Are they all the same?

Comment: No, not the database schema. I mean do they all have the same structure, same DDL?

Comment: Then as mentioned above, you can use the `ETL Metadata Injection` step. See the [Docs](https://help.pentaho.com/Documentation/6.1/0L0/0Y0/0K0/ETL_Metadata_Injection) for examples. Also check the sample directory.



{'source': 'StackExchangeDataset', 'subset': 'stackoverflow.com', 'metadata': {'AnswerCount': 0, 'CommentCount': 7, 'ContentLicense': 'CC BY-SA 3.0', 'CreationDate': '2016:00:06/17/16', 'FavoriteCount': None, 'PostTypeId': 1, 'Tags': '<pentaho><transformation><kettle>', 'Title': 'How to pass source table name and target table name from text file in pentaho ETL', 'ViewCount': 180, 'id': 37882112, 'user_AboutMe': None, 'user_AccountId': 8654827.0, 'user_DisplayName': 'Divya', 'user_Reputation': 9.0, 'user_Views': 3.0, 'user_id': 6479430.0}}