reusable job that can take 2 files and comp based on keys

kailas · 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 · Post by **keshav0307** » Thu Apr 02, 2009 7:02 pm

YES.
you need to elaborate and be specific on your requirement.

ray.wurlod · Post by **ray.wurlod** » Thu Apr 02, 2009 7:10 pm

"Supplied keys"? Supplied how (in a generic design)?

kailas · 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 · 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.

kailas · 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 · 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".