Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.
Moderators: chulett , rschirm , roy
kailas
Participant
Posts: 21 Joined: Mon Nov 17, 2008 11:49 pm
Location: bangalore
Post
by kailas » Thu Apr 02, 2009 5:30 am
Hi ,
Is it possible to develop a reusable/configurable job that can take 2 files and compare based on supplied keys. It should be generic and allow configuration supplied at run time what is source and destination and what are the fields to compare .
keshav0307
Premium Member
Posts: 783 Joined: Mon Jan 16, 2006 10:17 pm
Location: Sydney, Australia
Post
by keshav0307 » Thu Apr 02, 2009 7:02 pm
YES.
you need to elaborate and be specific on your requirement.
ray.wurlod
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Post
by ray.wurlod » Thu Apr 02, 2009 7:10 pm
"Supplied keys"? Supplied how (in a generic design)?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
kailas
Participant
Posts: 21 Joined: Mon Nov 17, 2008 11:49 pm
Location: bangalore
Post
by kailas » Thu Apr 02, 2009 10:10 pm
[quote="ray.wurlod"]"Supplied keys"? Supplied how (in a generic design)? ...[/quote]
I mean the comparision between two files will be based on key fields and these keyfields (fields to be compared )are to be supplied at run time.
Let me know if it is still not clear .
Thanks
ray.wurlod
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Post
by ray.wurlod » Thu Apr 02, 2009 10:12 pm
If you intend to supply key fields then suddenly things are no longer "dynamic" or "generic" in terms of metadata. Had you given any thought as to how you will be "supplying" keys? Metadata can not be affected by job parameters, at least not directly.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
kailas
Participant
Posts: 21 Joined: Mon Nov 17, 2008 11:49 pm
Location: bangalore
Post
by kailas » Thu Apr 02, 2009 10:48 pm
Ray,
Just give me an idea how to develop the reusable job to compare two files based on key values. The fields to be compared should be generic.
Thanks
ray.wurlod
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Post
by ray.wurlod » Thu Apr 02, 2009 11:36 pm
Ok. IT IS NOT POSSIBLE.
You can not have your cake and eat it too. If you have to "specify" keys then it is not "generic".
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.