How to execute .ktr file in linux with data parameters(another transformation)?

Question

As the question says, I would like to execute the .ktr file but via Linux

I tryied to execute test.ktr like this :

sh pan.sh -file="/path/to/test.ktr"

I got an error of : Unable to get database metadata from this database connection, Error connecting to database [${DATABASE_NAME}]

Before executing test.ktr, I have to execute set_database_parameters.ktr firstly, I have many transformations like test.ktr, that's the reason why I set a set_database_parameters.ktr file specially it there a way to solve it? Thanks so much

Answer 1

Use a job to execute the transformations sequencially and execute the job, not the transformations separately