Need an approach to implement multiple files creation based on values which are dynamic. The value is used in SELECT clause of a query. Have to create all the files parallel.
Used loop activity stage which is consuming more time because it takes one value at a time and runs the query.
Example:
SELECT NAME, DESIGNATION from EMPLOYEE where DEPT_NM=#JP_DEPT_NM#
Here Department name is dynamic means they might need information for 5 departments on a given day or sometimes 50 departments on a given day
Appreciate your help.
Thanks
create multiple files in parallel based on values
Moderators: chulett, rschirm, roy
create multiple files in parallel based on values
______________________________________
"Everytime I close the door on reality, it comes in through the windows." - Jennifer Yane
"Everytime I close the door on reality, it comes in through the windows." - Jennifer Yane
-
- Participant
- Posts: 251
- Joined: Mon Jun 09, 2008 5:52 am
Create multiple files parallel by using dynamic values
Could you please elaborate the logic.chulett wrote:Create a work table, load the list of values there, join with your table. ...
Thanks.
______________________________________
"Everytime I close the door on reality, it comes in through the windows." - Jennifer Yane
"Everytime I close the door on reality, it comes in through the windows." - Jennifer Yane
create multiple files in parallel based on values
Could you please explain me how to run the multiple instance sequence for the dynamic list of values.srinivas.g wrote:Or you can use Allow multiple instance option
Thanks
______________________________________
"Everytime I close the door on reality, it comes in through the windows." - Jennifer Yane
"Everytime I close the door on reality, it comes in through the windows." - Jennifer Yane
Re: Create multiple files parallel by using dynamic values
Which part is unclear? Your particular work table would have a single column in it for DEPT_NM which you would load with whatever values needed to be used to constrain the current run. Then modify your SQL to be something like:dsrules wrote:Could you please elaborate the logic.chulett wrote:Create a work table, load the list of values there, join with your table. ...
SELECT NAME, DESIGNATION from EMPLOYEE, WORK where EMPLOYEE.DEPT_NM = WORK.DEPT_NM
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
Re: Create multiple files parallel by using dynamic values
Not able to view the whole message. How do I join to work table and populate files which is not clear to me.chulett wrote:Which part is unclear? Your p ...dsrules wrote:Could you please elaborate the logic.chulett wrote:Create a work table, load the list of values there, join with your table. ...
Example: My list file has 50 dept. numbers and I shall create 50 files in parallel.
Thanks
______________________________________
"Everytime I close the door on reality, it comes in through the windows." - Jennifer Yane
"Everytime I close the door on reality, it comes in through the windows." - Jennifer Yane