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.....
Join in Server Job
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 96
- Joined: Mon May 14, 2012 1:30 pm
Join in Server Job
Thanks,
Ankur Saxena
Ankur Saxena
Though it is difficult to understand the complete requirement on basis of the example, I believe that are you trying to insert records based on gaps.
If so, see this post. If not, try to explain the requirement in words.
If so, see this post. If not, try to explain the requirement in words.
Re: Join in Server Job
I would imagine, though, that someone gave you the task and requirements in words did they not?ankursaxena.2003 wrote:It is tough to put down the requirement in words.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Premium Member
- Posts: 1735
- Joined: Thu Mar 01, 2007 5:44 am
- Location: Troy, MI
Re: Join in Server Job
Yes, on what basis you are expecting these two records in output.ankursaxena.2003 wrote:Let me know if you have any questions.....
2 2 1 ghi
2 2 2 jkl
Priyadarshi Kunal
Genius may have its limitations, but stupidity is not thus handicapped.
Genius may have its limitations, but stupidity is not thus handicapped.