Friday, May 22, 2009

Using a Table Without Importing It

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

No comments:

Post a Comment