Six Stars

loading the context variable value after completion of a job

Hi All,

 

I have create one job with some context variable(values will changes over execution).

 

after end of the job i want load the context variable into a file using tPostJob.

 

How to do it?

 

Thanks

shree

1 ACCEPTED SOLUTION

Accepted Solutions
Six Stars

Re: loading the context variable value after completion of a job

Thanks @bshree88,for your confirmation.

 

Can you please accept my solution, This allows others to see what has worked.

 

Thanks,

Sachin

Lets share and learn!

 

 

9 REPLIES
Six Stars

Re: loading the context variable value after completion of a job

 

 

Hi @bshree88

 

You can use tContextDump, as shown below,

Please accept solution if you think it helps you, Thanks.

 

Thanks,

Sachin

 

 

Cn1.JPG

Six Stars

Re: loading the context variable value after completion of a job

Hi bshree88,

You can use tFixedflowInput as shown below,

Please accept as solution if  it helps you

 

Thanks,

Abhi529

Capture1.JPG

tfixedflowinput properties as,

 

Capture2.JPG

 

 

 

 

 

Six Stars

Re: loading the context variable value after completion of a job

Hi Sachin,

 

Can you show me the tFileOutputDelimited properties.

and one more there few context variables, the values of those variables changing at run time. i need to capture those values and store into file.

 

some other jobs i need to use this  context variable values  using tcontextload components.

 

Thanks

shree

 

 

Six Stars

Re: loading the context variable value after completion of a job

Hi Abhi529,

 

Can you show me the tFileOutputDelimited properties.

and one more there few context variables, the values of those variables changing at run time. i need to capture those values and store into file.

 

some other jobs i need to use this  context variable values  using tcontextload components.

 

Thanks

Shree

Six Stars

Re: loading the context variable value after completion of a job

Hi Shree,

 

tFileInputDelimited has basic properties set as

File Name, Filed Seperator

 

as you are capturing context variable in post jobs, you will get updated values of variables, as you mentioned variables are changing run time.

 

 

 

DD0.JPG

 

 

In another JOB.

u can use same created file and load the context variable in some another job using tContextLoad.

But Schema should be Key Value as shown below.

 

 

 

dd1.JPG

 

Please accept the solution if it helps you.

 

Thanks,

Sachin D.

Six Stars

Re: loading the context variable value after completion of a job

Thanks Sachin.

 

Sound good it's working fine.

 

Regards

Shridhar

Six Stars

Re: loading the context variable value after completion of a job

Thanks @bshree88,for your confirmation.

 

Can you please accept my solution, This allows others to see what has worked.

 

Thanks,

Sachin

Lets share and learn!

 

 

Six Stars

Re: loading the context variable value after completion of a job

Hi bshree88,

For your information,

here is the tFileOutputDelimited properties..

Capture_123.JPG

and schema is,

 

contextt.JPG

Six Stars

Re: loading the context variable value after completion of a job

Hi Sachin,

 

After completion of job is file is created. But it is not capturing latest values before compilation of job.

 

Please find the attached file for your references.

 

Thanks

Shree