Hi,
We have a requirement as follows.
1. We have a reference table which has the target table names, Column names (concatenated fields) and other business columns.
2. Many input datasets (from target) which has the columns defined for that dataset.
Now we have to look up the input dataset with the reference table (based on the dataset name)and fetch the column names from reference table and then compare the column names with the input dataset and provide the values (kind of snapshot).
We need to build a generic job and it will be running for each and every dataset.
Kindly let me know how can we achieve this.
Can we use RCP and schema file for the datasets? How to compare column names?
Thanks.
Need help on designing Datastage Job
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 8
- Joined: Wed Aug 30, 2006 3:50 am
- Location: the Netherlands
- Contact:
Let's start with what your processing job actually needs to do once it has all of this information, something I'm not clear on from your post. Let's say you generate your schema file and build an RCP job - what exactly does it need to do when it runs? That will determine how viable RCP itself is.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Build the target table name as a constant (perhaps using a Column Generator stage or a Transformer stage) upstream of the Lookup stage.
A generic approach might use a job parameter for the target table name.
A generic approach might use a job parameter for the target table 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: 18
- Joined: Wed Dec 09, 2009 2:16 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Get yourself a premium membership.
At less than 30c (Rs12) per day it's not expensive, and the revenue is devoted to the hosting and bandwidth costs incurred by DSXchange. So you're helping to keep the site alive.
At less than 30c (Rs12) per day it's not expensive, and the revenue is devoted to the hosting and bandwidth costs incurred by DSXchange. So you're helping to keep the site alive.
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.