Deriving job Info in a transformer
Posted: Sat Jul 11, 2009 12:30 am
I have a database stage which queries from a table of Job Names. It passes it to a transformer. In the transformer, i have the following derivations:
DSGetJobInfo(Lnk_Fr_table.job_name,DSJ.JOBSTATUS)
DSGetJobInfo(Lnk_Fr_table.job_name,DSJ.JOBSTARTTIMESTAMP)
DSGetJobInfo(Lnk_Fr_table.job_name,DSJ.JOBLASTTIMESTAMP)
but they return 0s and 1s instead of the actual string values.
What's wrong with these derivations??
DSGetJobInfo(Lnk_Fr_table.job_name,DSJ.JOBSTATUS)
DSGetJobInfo(Lnk_Fr_table.job_name,DSJ.JOBSTARTTIMESTAMP)
DSGetJobInfo(Lnk_Fr_table.job_name,DSJ.JOBLASTTIMESTAMP)
but they return 0s and 1s instead of the actual string values.
What's wrong with these derivations??