Hash File

[Raftsman]

I created an exception Hash file.

Loc_cd
Strt_tm
End_tm


I combined two tables, DB2 and hash file using a Loc_cd. During the join, it is possible that some codes on the DB2 table will not match the hash table. If there is no match I would like to pass a default strt_tm and End_tm that isn't in the hash file. Is there a way to do this.

Thanks

[ray.wurlod]

In the Transformer stage detect whether the lookup succeeded (if not, LocCd from that link will be null) using If .. Then .. Else, and supply your default values in that expression.