FastTrack Mapping
Posted: Thu Jul 07, 2011 2:34 am
Hello everyone,
I am trying to create a simple mapping between two tables TBL_A, TBL_B (residing in a DB2 over z/OS) inside fasttrack v.8.5 (over Linux) and generate a Datastage job. I have imported the metadata of the tables inside FastTrack and used the repository/metadata sharing/create table definition from shared table menu to import the definition inside the datastage.
Then I define the sources and targets for the new mapping by dragging and dropping the TBL_A, TBL_B respectively in the areas of source and target in the scope of the new mapping.
I then mapped TBL_A.col_1 to TBL_B.col_1 (same names) and generated the job. The end result was a parallel job with two connectors and one transformer stage. But inside the transformer the columns that were mapped were TBL_A.col_1 to TBL_B.col_x, where col_x is another column of TBL_B.
Does anyone have any idea why is this happening?
No matter how many times I tried I couldn't get it to map the chosen columns.
Thank you
I am trying to create a simple mapping between two tables TBL_A, TBL_B (residing in a DB2 over z/OS) inside fasttrack v.8.5 (over Linux) and generate a Datastage job. I have imported the metadata of the tables inside FastTrack and used the repository/metadata sharing/create table definition from shared table menu to import the definition inside the datastage.
Then I define the sources and targets for the new mapping by dragging and dropping the TBL_A, TBL_B respectively in the areas of source and target in the scope of the new mapping.
I then mapped TBL_A.col_1 to TBL_B.col_1 (same names) and generated the job. The end result was a parallel job with two connectors and one transformer stage. But inside the transformer the columns that were mapped were TBL_A.col_1 to TBL_B.col_x, where col_x is another column of TBL_B.
Does anyone have any idea why is this happening?
No matter how many times I tried I couldn't get it to map the chosen columns.
Thank you