Hi,
I have a requirement, where i need to find out the Source Table column names to Target column names. We are using ODBC stage to connect Oracle database, used user defined queries to join multiple tables to get the data and writing it to a sequential file. Now I have a task to get the Source table name, Source column name mapped with destination column name .. Is there a easy way to get what i needed, or do i need to open the job , SQL and manually map with target file columns.
Pls, any ideas, approaches !!
thanks in advance!
Source and Target mapping data
Moderators: chulett, rschirm, roy
Hi,
In a perferct world your requirement would have been prepared before you actually designed your job.
Since were not living in a perfect wold (at least it seems that way) you will need to do it manually or by building reports.
Such reports might be achieved by utilising the html reports you can generate or perhaps even via Kim's etlstats and such tools he built and you can take a peek at he's site.
Also take a look here
IHTH,
In a perferct world your requirement would have been prepared before you actually designed your job.
Since were not living in a perfect wold (at least it seems that way) you will need to do it manually or by building reports.
Such reports might be achieved by utilising the html reports you can generate or perhaps even via Kim's etlstats and such tools he built and you can take a peek at he's site.
Also take a look here
IHTH,
Roy R.
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
![Image](http://www.worldcommunitygrid.org/images/logo.gif)
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
![Image](http://www.worldcommunitygrid.org/images/logo.gif)
Thanks roy! you are correct we need do the mapping before developing the code. But the requirement is now to trace back..
I generated a .XML file it has the souce and target column names. Can any one help me out with sample how to use XML stage to parse the .XML input file to Sequential file.
I tried as follows but it has lot of parameters, where do i specify the Input file name.. any help is appreciated!
XML INput stage ------> XML Transformer ------> Seq
Thanks
![Smile :-)](./images/smilies/icon_smile.gif)
I generated a .XML file it has the souce and target column names. Can any one help me out with sample how to use XML stage to parse the .XML input file to Sequential file.
I tried as follows but it has lot of parameters, where do i specify the Input file name.. any help is appreciated!
XML INput stage ------> XML Transformer ------> Seq
Thanks
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Why not just use a lineage analysis? (You need MetaStage for this, but that's now being pushed as the reporting tool of choice, so you may as well buy now - resistance is useless!!)
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: 3593
- Joined: Thu Jan 23, 2003 5:25 pm
- Location: Australia, Melbourne
- Contact:
One of my personal bugbears is transformation within user-defined SQL. Have a look at it in detail, find out if it renames columns or runs functions on columns. This type of manipulation occurs outside of your DataStage job (on the RDBMS) and can be hidden from some data lineage reporting.
To turn an XML file into a sequential file just import the XML definition into the Manager tool and link your XML Input to a transformer and sequential file output stage. You shouldn't need an XML transform stage.
Then again why turn it into a sequential file? You can view XML in a browser and write your own XSL stylesheets to format it for viewing. There are some sample XSL stylesheets in the DataStage client directory that are designed to format DataStage export XML files.
To turn an XML file into a sequential file just import the XML definition into the Manager tool and link your XML Input to a transformer and sequential file output stage. You shouldn't need an XML transform stage.
Then again why turn it into a sequential file? You can view XML in a browser and write your own XSL stylesheets to format it for viewing. There are some sample XSL stylesheets in the DataStage client directory that are designed to format DataStage export XML files.
Certus Solutions
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
As you mentioned Yes! there are lot of transformations from source to Destinations, column names been changed.To turn an XML file into a sequential file just import the XML definition into the Manager tool and link your XML Input to a transformer and sequential file output stage. You shouldn't need an XML transform stage.
Could you please tell me ' Do I need to use XML Input stage then to regular Transformer and to Seq output is it?
XML Input Stage =====> XFRM =====> SEQ.
thanks
-
- Participant
- Posts: 3593
- Joined: Thu Jan 23, 2003 5:25 pm
- Location: Australia, Melbourne
- Contact:
Yes, that will do it. The XML input stage will "flatten" your XML data into a single record type which can easily be handled by a normal transformer.
Certus Solutions
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: