Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

Insight: Looking for the job that updates ETL_INFO table

Questions
Tags
Users
Badges
Timur Markunin
(649●5●166●146) Feb 06 '13, 5:43 a.m.
 Hello,

I'm creating my own ETL job. I need to implement incremental behaviour so I want to utilize $MODIFIED_SINCE variable. 
My understanding is that I need to somehow insert info about last successful run of my job into ETL_INFO table and then initialize $MODIFIED_SINCE using GetNFLastETLSuccessDateTime function.

Am I right? How could I insert data into ETL_INFO?

-thanks in advance

1

0 votes

1 answer
6,797 views
0 votes

Accepted answer

Permanent link
Junli Wang
JAZZ DEVELOPER (551●2) Feb 06 '13, 6:08 a.m.
just use a procedure node containing the user defined function: SetNFETLStatusDateTime, at the end of your job.
this function will insert data into ETL_INFO table.
you may refer to the existing jobs doing this, eg Jobs->CQJobs->ALM

Timur Markunin selected this answer as the correct answer

2 votes

Comments
Timur Markunin
Feb 06 '13, 7:39 a.m.
Thanks Junli! Maybe you could also comment on $RESULT variable usage? I use following procedure: IF($RESULT2=TRUE) then SetNFETLStatusDateTime(... In execution log I have: ............................. [PROGRESS   - 12:29:55] Build Node 2 'Sber_Timesheet'; succeeded [VARIABLE   - 12:29:55] RESULT = TRUE ..... [PROGRESS   - 12:29:55] Procedure Node 3 'SetFinishedTime'; reported the following: DM-EXP-0003 An expression validation error occurred at position 3 Unknown variable '$RESULT2'. I don't understand how I could use $RESULT variable....

Junli Wang
JAZZ DEVELOPER Feb 06 '13, 7:59 a.m.
right click on the build in the job, open the Properties window,  the second tab 'Details', there is a text box you can define the result variable, eg. you input 'Result1', in the later procedure node, Result1 will be referred as the result of this build.

Your answer

Register or log in to post your answer.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.

Ask a question
Guidelines
FAQ
Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 12,145

Question asked: Feb 06 '13, 5:43 a.m.

Question was seen: 6,797 times

Last updated: Feb 06 '13, 7:59 a.m.

Confirmation Cancel Confirm