two flow job with 2 lookups job running long time
Posted: Sat Oct 22, 2011 7:40 am
Hi,
I have a requirement. Based on the input column value, I need to insert one record as a two records with different values in other respective columns by getting from lookup tables. My job flow is like below
This job is running for long time, and not finishing. After I dividing this job to 2 jobs as Oracle1, Traansformer1,lookup1, transformer2,dataset as a one job. and other job as oracle1, transformer1, Lookup2, Transformer3, dataset with same lookup in 1, 2 nd jobs. These job are running fine. But actual flow as shown above is not working. Please give me the suggestions to do this job in single job.
I have a requirement. Based on the input column value, I need to insert one record as a two records with different values in other respective columns by getting from lookup tables. My job flow is like below
Code: Select all
Oracle1--->Transformer1---------->Lookup1-----------------> Transformer2-----
| ^ ^ ^ |
| | | | |
| Oracle2----->Filter1 Filter2<-----Oracle3 Funnel---->dataset
| | | | | |
| v v v v |
|--------------->Lookup2-----------------> Transformer3------