Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Talend Cloud AWS EU Scheduled Outage: Starting Tues 26 May 21:00 CEST with expected completion Wed 27 May 01:00 CEST
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Multiple oncompoentok is all true

0683p000009M6Cp.png

This is my job design. I want to do tFileCopy_3 after all output tables such as productSpecs, SetUp, Order and OrderDetails's OnComponentOK is true. How do i catch the condition if onComponentOk on these tables are true? I want to copy file if only inserting data on these tables are true.

Labels (2)
6 Replies
fdenis
Master
Master

split your big job on by 2...
then create a job for orchestration using trunjob.
it's the cleanest way.
you can split your job on:
firstCopyFiles
runingNumber
insertIntoDb
ArchiveFile
Anonymous
Not applicable
Author

I need to move file on each success inserting data into database from xml file.
fdenis
Master
Master

in this case you can use tparallelize
let's go
Anonymous
Not applicable
Author

where should i put tparallelize and connect?
fdenis
Master
Master

you have to split and parallelize your 4 insert process then to merge with tparallelize. press f1 on selected component to have samples.
lennelei
Creator III
Creator III

Hi,
1) Replace the OnComponentOk between both tFileList with a OnSubjobOk (more readable)
2) Move the tDBConnection before the first tFileList and add a OnSubjobOk link between them (to be sure the DB connection is made before the rest and that the job will stop if the connection fails)
3) Put your tFileCopy_3 below the tFileInputXML_1 after a OnSubjobOk link (to be sure the tFileCopy is made after the whole XML read/Oracle Input part)

4) I would personnaly remove the tRollback and add a tOracleClose (it's best to always close the connection and if you don't commit and close the connection, the rollback will be made)

 

You'll end up with somethind like this:

0683p000009M6GN.png

Regards