Kettle Load csv data into multiple tables?

This is very easy. Have you downloaded spoon and started it up yet (The editor for creating transformations) Create a text file input Copy the data from text file input to a group by step to group by department, and then to an insert/update step to get your DEPARTMENT table Copy the data from text file input to another insert/update table step to create your employee table As for the ID's you can allow the database to generate those as autonumber fields if you like - and do the lookup on whatever the unique requirement is I strongly reccomend downloading the tool and having a play - it's so easy once you start.

This is very easy. Have you downloaded spoon and started it up yet (The editor for creating transformations) Create a text file input Copy the data from text file input to a group by step to group by department, and then to an insert/update step to get your DEPARTMENT table Copy the data from text file input to another insert/update table step to create your employee table As for the ID's you can allow the database to generate those as autonumber fields if you like - and do the lookup on whatever the unique requirement is. I strongly reccomend downloading the tool and having a play - it's so easy once you start.

I downloaded it, but not really sure what widgets to use and options to choose. Forgot to mention, the 'id's in 2 tables are auto generated sequences by DB. VHow do I pull id from Department table to use in Employee table while inserting.

If easy a screenshot or kettle would help. – Sam Keith Mar 24 at 23:38 I know this comment is quite old now, but there is a "Add sequence" step within pentaho which you could use before inserting into the tables to retrieve the next ID from the DB sequence and then insert into both tables along with your input file data. – t_barbz Nov 7 at 15:51.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.