Page 1 of 1
reusable job that can take 2 files and comp based on keys
Posted: Thu Apr 02, 2009 5:30 am
by kailas
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 .
Posted: Thu Apr 02, 2009 7:02 pm
by keshav0307
YES.
you need to elaborate and be specific on your requirement.
Posted: Thu Apr 02, 2009 7:10 pm
by ray.wurlod
"Supplied keys"? Supplied how (in a generic design)?
Posted: Thu Apr 02, 2009 10:10 pm
by kailas
[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
Posted: Thu Apr 02, 2009 10:12 pm
by ray.wurlod
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.
Posted: Thu Apr 02, 2009 10:48 pm
by kailas
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
Posted: Thu Apr 02, 2009 11:36 pm
by ray.wurlod
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".