In SQL Transform :
1)Create Output Columns that are required by seeing the table structure in the backend.
2)Do not import the table in the respective DataStore(The Schema i.e Connected with in which the table is available).
3)Select the appropriate DataStore in which the actual table is residing in the Backend but not in the datastore.
4)Write the appropriate SQL Query as per the columns created.
5)If you want, you can use the global variable which represent the respective schema name.
6) Do not click on the Update Schema.
7)Implement the Transformation Logic i.e required in the job.
8)Execute the job
1)Create Output Columns that are required by seeing the table structure in the backend.
2)Do not import the table in the respective DataStore(The Schema i.e Connected with in which the table is available).
3)Select the appropriate DataStore in which the actual table is residing in the Backend but not in the datastore.
4)Write the appropriate SQL Query as per the columns created.
5)If you want, you can use the global variable which represent the respective schema name.
6) Do not click on the Update Schema.
7)Implement the Transformation Logic i.e required in the job.
8)Execute the job
