Hi there,
in general , i would like to know
1.how to restore the memory table from sashdat in coding form.
2. how to memory table does not exists but sashdat is available
in the ETL we build, we saved a sashdat physical data each time some actions performed against the CAS table. in certain occasions, the memory table flushed out and the ETL did not have the restore process from the sashdat, it treated as new memory table and restart as a new fresh memory table .
to avoid it, i would like to know if any programming or option that i can use in ETL to detect missing
the simple procedures as now :
step1 if cas table exists we append the record else new cas table exists we append the record
step2 save sashdat
the new procedure we would like to do are :
step1 if there is sashdat table , and in memory table not there , restore first then proceed to step2 .
step2 if cas table exists we append the record else new cas table exists we append the record
step3 save sashdat
... View more