job parameters

kavuri · Post by **kavuri** » Wed Jul 18, 2007 2:43 pm

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

ray.wurlod · Post by **ray.wurlod** » Wed Jul 18, 2007 3:14 pm

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.