Join in Server Job
Posted: Fri Aug 07, 2015 4:30 pm
i have a requirement for server job. But if there is a solution with parallel job, then i can make a parallel job also. And below is an example.
It is tough to put down the requirement in words. So i will explain with an example.
For example, Table 1 is the source and table 2 is reference table. For row 5 in table 1 has (2,2,3) combination, then my output should also print for combination (2,2,1) and (2,2,2).
Table 1 (input)
col1 col2 col3
1 1 1 --> row 1
1 1 2 --> row 2
2 1 1 --> row 3
2 1 2 --> row 4
2 2 3 --> row 5
Table 2 (reference)
col1 col2 col3 col4
1 1 1 abc
1 1 2 def
2 1 1 ghi
2 1 2 jkl
2 2 3 mno
Output:
Table
col1 col2 col3 col4
1 1 1 abc
1 1 2 def
2 1 1 ghi
2 1 2 jkl
2 2 1 ghi
2 2 2 jkl
2 2 3 mno
Let me know if you have any questions.....
It is tough to put down the requirement in words. So i will explain with an example.
For example, Table 1 is the source and table 2 is reference table. For row 5 in table 1 has (2,2,3) combination, then my output should also print for combination (2,2,1) and (2,2,2).
Table 1 (input)
col1 col2 col3
1 1 1 --> row 1
1 1 2 --> row 2
2 1 1 --> row 3
2 1 2 --> row 4
2 2 3 --> row 5
Table 2 (reference)
col1 col2 col3 col4
1 1 1 abc
1 1 2 def
2 1 1 ghi
2 1 2 jkl
2 2 3 mno
Output:
Table
col1 col2 col3 col4
1 1 1 abc
1 1 2 def
2 1 1 ghi
2 1 2 jkl
2 2 1 ghi
2 2 2 jkl
2 2 3 mno
Let me know if you have any questions.....