comaprison

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

Post Reply
ketanshah123
Participant
Posts: 88
Joined: Wed Apr 05, 2006 1:04 am

comaprison

Post by ketanshah123 »

Hi
I would like to comapre three data file hvng following column
<number><value1><value2>
In three files I would like to check/compare for every matching number in three file both values value1 and value2 must be matched.

so what would be the best way to implement it consider following schenarios ?

1)If any no. present in one or two files but not in third ?
2)If any no. present in one file and not in other two?


(Thugh before comparision it is validated that number is not missing.. )
Post Reply