Hi,
here I have to develop a job so that I have to load the target datawarehouse with the 3 years history. Once it happens I need to upsert the warehouse monthly with the new data.
here I would like to use startdate and end date as the parameters for determining the data extracted from database. Is this sufficient for the whole process or do I need to build different jobs for initial loading and montly loading.
Please give me some idea.
Thanks
Kavuri
job parameters
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
The nice thing about job parameters is that they give you this flexibilty - you will not need different jobs for initial load unless there are some conditions (such as differently-formatted legacy records) about which you have chosen not to inform us when posing your question.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.