Posted: Tue Mar 14, 2006 10:36 pm
Craig..I am not sure how occasionally it might be, that's the requirement.
Creating another job might be an option but, again I need to create whole lot of jobs for each job in my sequence(for each table I load data into) which as Naveen mentioned, and I feel is like wasting resources, because I would be running those jobs only once in a while. And, I need to insert data into my table once the table is truncated. So, I am kinda getting lost here. So need to regroup my thoughts here a bit. Will keep you all posted.
Thanks
Kris.
Or even create a separate job in datastage to truncate table and run it manually whenever you want to truncate table....
Creating another job might be an option but, again I need to create whole lot of jobs for each job in my sequence(for each table I load data into) which as Naveen mentioned, and I feel is like wasting resources, because I would be running those jobs only once in a while. And, I need to insert data into my table once the table is truncated. So, I am kinda getting lost here. So need to regroup my thoughts here a bit. Will keep you all posted.
Thanks
Kris.