You are not logged in.
Is is possible to merge two data flows that have the same schema and are on the same iterative branch of a job, like in the following case
____ tSampleRow (Table1, Schema 1)
tOracleInput ----> tMap -< Merging possible?
\____ tSampleRow (Table2, Schema 1)
Thanks in advance,
From what I know, merging is possible with "tUnite" component, but you won't be able to merge your 2 tSampleRows outputs because you cannot perform any loop. Maybe use a temp file.
Anyway, why merging ? You can't find another way with you tMap ?
Talend don't allow a cycle flow in a job, see [Forum, topic 1468] multiple tAgregateRow and tMap components.
Hi, thanks for your answer, I read carefully the topic you linked, which explain why it isn't possible. I also floowed a link in this thread pointing to another topic expalining how to bypass this restriction in two distincts manners by using fileDelimited.
I tested them and they fullfil my wishes but I can't help noticing that in my case this solution is less efficient than duplicating whole subjob (meaning that reloading all data twice and making same tMap twice). This is mainly because of poor performance in insertion from a DelimitedFile.
Does Somebody know anyway to improve speed in this kind of operation? What about a similar solution using tOutputBulk and its familly? I couldn't find a solution using these components by myself.
(meaning that reloading all data twice and making same tMap twice)
Can you upload a screenshot of your current job?
Does Somebody know anyway to improve speed in this kind of operation? What about a similar solution using tOutputBulk and its familly?
1)Yes, the txxxOutputBulk component will improve performance than txxxOuput component. You can read the user documentation and learn its usage.
2)Try to add filter conditon in your sql statement if you can.