1) Pentaho/Spoon DI job unzips files & creates sqlite.db file with all those files converted to tables.( used Shell) 2)Couple of tables are to be added to the Sqlite.db from Mysql db using queries.( used table i/p o/p) 2) is a transformation that runs fine individually.
Although the whole job with transformations runs fine too - no error- only that step2) data from queries are not in the Sqlite.db.
In short, a job to create sqlite.db file is able to add tables from files ( maybe bcz it is done in the job itself & not in tranformation) but the ones from Mysql queries in transformation dont make it to the same Sqlite.db.
