How to control a table in SAS DI

[Shakti_Sourav]

Dear Team,

I am getting 0 value in the target value if there is any job failed. 

Is there any condition used that if the Source table is missing or not maximum year then it can't b truncate and loaded into the Target table? is there any Precode or Postcode available in Table Loader?

[LinusH]

Can you specify what you mean by "target value"?

If source table is missing, you will probably get an error.

For maximum year - I don understand exactly what you wish to do, but youcan probably do a pre-code in Table laoder to find out the year from source data and compare to target table. To affect the actual load logic might be tricky though - depends on how/what you actually want to do.