lookup operator.
Posted: Thu Sep 23, 2004 10:50 pm
..hi.
.. lets say we have the following requirement...
..there is a decimal field in ur CFD (u r reading from a Mainframe file) say X..and in ur job u perform a lookup where one of the reference links is from a LkpFileset..now what u have to do is .. when the lookup is successfull, u need to get the value of X from the refernce link, and when the lookup is unsuccessfull then u want a default value to be present for our clmn X..How do u accomplish this witout using the Transformer....the operators that i am uing are .. primary source : datset, reference source : LkpFileset, and a lookup operator..target: datset.
all inputs are welcome..
now in a server job ur reference source is a hash file and in ur Xfmer.. u specify If LookUp Found do this else do that.. how do u get the same funcationalty in PX..
sorry for the length of the msg..but i hope u got my point..
thanks,
srikanth.
.. lets say we have the following requirement...
..there is a decimal field in ur CFD (u r reading from a Mainframe file) say X..and in ur job u perform a lookup where one of the reference links is from a LkpFileset..now what u have to do is .. when the lookup is successfull, u need to get the value of X from the refernce link, and when the lookup is unsuccessfull then u want a default value to be present for our clmn X..How do u accomplish this witout using the Transformer....the operators that i am uing are .. primary source : datset, reference source : LkpFileset, and a lookup operator..target: datset.
all inputs are welcome..
now in a server job ur reference source is a hash file and in ur Xfmer.. u specify If LookUp Found do this else do that.. how do u get the same funcationalty in PX..
sorry for the length of the msg..but i hope u got my point..
thanks,
srikanth.