WarOne Posted April 20, 2015 Share Posted April 20, 2015 This is a screenshot of one of my ETL job. As you can see tMap_1 will produce output to site_out and site_out_update (Both is tMSSqlOutput component). On my tJava_1 i have the following simple code (as shown in the bottom of the image). When i run this, the console output the word "test" 2 times. Which i assumed tJava_1 have been executed 2 times by both site_out and site_out_update. My really simple question is how to make tJava_1 executed only once? to make it clear, tJava_1 will be executed only after tMap_1 have already finished inserting all the data to both site_out and site_out_update. Can somebody help me on this. Is there a component which can combine both the OnComponentOk link into 1 or something. Please help. thanks in advanceP/S: pardon my bad english if any :pP/S: in the picture, i have mispelled syntax. (it suppose to be "System ..." not "Syatem ...") ignore it please. just pretend im using the right one :P Link to comment Share on other sites More sharing options...
Solution marianol Posted April 21, 2015 Solution Share Posted April 21, 2015 Indeed is doing the right thing, each component will trigger a OnComponetOk signal whn it finished giving you 2 fires of your tJava component.What you are looking for is not "OnComponetOk" but "OnSubJobOk" that will get triggered only once when the first subjob finish.. something like this: Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now