Hi,
I wanted to pass the record count value of particular table from one task to another task. Hence I used save_data function first task. I couldn't choose any variable so I saved it using job_name() function.
save_data(job_name(), RECORD_COUNT)
This was the mapping done in one of the temp column in the transform.
When I tried to fetch the value in second task. It is not working and returning NULL value.
I thought save_data would create a persistent variable.
Please help. Also let me know if there are options from for above requirement.
Thanks,
Anil