Hi
Is it possible wherein we can change the job parameter based upon each of the input record.
To be more specific i have scenario wherein i want to do join of input A with input B. For each record in the input A i need to fire specific query to fetch records for B, which i will then be use for join.
Any suggestions on how to go about it?
TIA
Akash
Is it possible to change job parameter based on each record
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 27
- Joined: Fri Aug 13, 2004 3:36 am
- Location: INDIA
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Premium Member
- Posts: 70
- Joined: Thu Aug 14, 2003 6:24 am
- Contact:
Re: Is it possible to change job parameter based on each rec
If both Input A and Input B in Database, use join query in paralle extender to get performance. If not you better to create temp tables in DB to do that. If you are not sure what distinct values you get from input value set and size for Input A, you must use DB concepts. that makes easy to test the application too.akash_nitj wrote:Hi
Is it possible wherein we can change the job parameter based upon each of the input record.
To be more specific i have scenario wherein i want to do join of input A with input B. For each record in the input A i need to fire specific query to fetch records for B, which i will then be use for join.
Any suggestions on how to go about it?
TIA
Akash
-
- Premium Member
- Posts: 70
- Joined: Thu Aug 14, 2003 6:24 am
- Contact:
Re: Is it possible to change job parameter based on each rec
If both sources in flat files and value sets are big, you better consider sorting and matching and query generation can be done in Shell scripts an AWK. If not in flat files, but in DB you can consider generating, running an sql queries from shell and AWK( data dump in flat files), linked to DS as after or before jobs routines also an optional. I don't about your env.s_boyapati wrote:If both Input A and Input B in Database, use join query in paralle extender to get performance. If not you better to create temp tables in DB to do that. If you are not sure what distinct values you get from input value set and size for Input A, you must use DB concepts. that makes easy to test the application too.akash_nitj wrote:Hi
Is it possible wherein we can change the job parameter based upon each of the input record.
To be more specific i have scenario wherein i want to do join of input A with input B. For each record in the input A i need to fire specific query to fetch records for B, which i will then be use for join.
Any suggestions on how to go about it?
TIA
Akash