Source to Target mapping
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Maybe it's something simple, like the fact that you left the trailing semi-colon off the SQL query.
Each link has two "pin" entries (a pin is the end of a link, that connects to a stage). Link entries in DS_JOBOBJECTS have an identity of the form VnSmPk where n is the view number (job or container), m is the stage number and k is the pin number.
Each link has two "pin" entries (a pin is the end of a link, that connects to a stage). Link entries in DS_JOBOBJECTS have an identity of the form VnSmPk where n is the view number (job or container), m is the stage number and k is the pin number.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
You mentioned BG in your initial post........do you have Metadata Workbench installed? That would potentially be another way to get the connection details you are looking for...
Ernie
Ernie
Ernie Ostic
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
Thanks for all your responses.
Hi Ernie,
We explored BG option but it did not work out very well due to some internal constraints.
Hi Ray,
Simple source to target mapping in transformer is as mentioned below.
Source columns:
Emp Name (Varchar (30))
Emp Salary Decimal (18,3)
Target Columns:
Emp_Name (Varchar(30))
Emp_No Integer
Emp_Salary Decimal(18,3)
Source to Target Mapping in Transformer is:
Target Column Source Column
Emp_Name Emp Name
Emp_No @INROWNUM
Emp_Salary Emp Salary
What i am trying to achieve here is as below.
Target Column Source Column
Emp_Name Emp Name
Emp_No @INROWNUM
Emp_Salary Emp Salary
Thanks in advance for your help.
Regards
Elavenil
Hi Ernie,
We explored BG option but it did not work out very well due to some internal constraints.
Hi Ray,
Simple source to target mapping in transformer is as mentioned below.
Source columns:
Emp Name (Varchar (30))
Emp Salary Decimal (18,3)
Target Columns:
Emp_Name (Varchar(30))
Emp_No Integer
Emp_Salary Decimal(18,3)
Source to Target Mapping in Transformer is:
Target Column Source Column
Emp_Name Emp Name
Emp_No @INROWNUM
Emp_Salary Emp Salary
What i am trying to achieve here is as below.
Target Column Source Column
Emp_Name Emp Name
Emp_No @INROWNUM
Emp_Salary Emp Salary
Thanks in advance for your help.
Regards
Elavenil
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
OK, I'm not on site till Monday, but you're basically looking for those records in DS_JOBOBJECTS that have an OLETYPE that indicates that they are output links from Transformer stage.
Without access to DataStage I can't tell you which field in the record contains the column names and which contains the output derivation expressions, but they're in there. Is that all you need, or would you be needful of the output constraint also?
Without access to DataStage I can't tell you which field in the record contains the column names and which contains the output derivation expressions, but they're in there. Is that all you need, or would you be needful of the output constraint also?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
I've had similar success using DataStage to read the xml variant of a .dsx file.
Ernie
Ernie
Ernie Ostic
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
The output pin from a Transformer stage has an OLETYPE of CTrxOutput in its DS_JOBOBJECTS record.
Within this record, multivalued field numbers 14-34 describe the columns on the link and, specifically, the derivation expressions are in field number 25.
To see just this, try something like
Within this record, multivalued field numbers 14-34 describe the columns on the link and, specifically, the derivation expressions are in field number 25.
To see just this, try something like
Code: Select all
SELECT EVAL "@RECORD<14>" AS COLUMN_NAME FMT '26L', EVAL "@RECORD<25>" AS DERIVATIONS FMT '40L' FROM DS_JOBOBJECTS WHERE OLETYPE = 'CTrxOutput' AND OBJIDNO = (SELECT JOBNO FROM DS_JOBS WHERE NAME = '<<Job name>>');
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Search here or UniVerse manuals for COMO and DIVERT.OUT commands.
Your output will be in ./\&COMO\&/derivations.txt
Or use SETPTR command mode 3 to direct output to a hold file when the LPTR keyword is used.
Your output will be in ./\&HOLD\&/derivations.txt
Code: Select all
COMO ON derivations.txt
SELECT .... ;
Or use SETPTR command mode 3 to direct output to a hold file when the LPTR keyword is used.
Code: Select all
SETPTR 1,132,20000,0,0,3,BANNER derivations.txt
SELECT ..... LPTR 1;
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.