DSXchange

You are right in that you can build as much parallelism into the batch job, but the OP requirement is for restartability from point of failure without using sequencers. So in the typical control job the jobs will be stepped through in sequence using a FOR loop. The scenario provided by the OP was th...

You can always use the BASIC language and write a DS batch job. Include a FOR NEXT loop in there with parameterised FROM and TO, that way when you need to rerun you can choose which point to start and which point to end. In this case you will limit your run to a sequential run though.

[quote="basav_ds"]Hi, When we have only Dimesion source data, Can we update only dimensional table without updating the fact table using Slowly Changing Dimension Stage? Or is it mandatory to load fact table too?[/quote You can just load your dimension tables first but make sure you have p...

In your logs do you see any SQL errors?

Do you have the required C compilers installed? What version of Windows server are you running with?

Your error sounds like a DB2 error (I'm guessing here). If it is it's an internal error ,one of those nasty ones which is hard to debug. You might need to raise this to your DBAs. It's not a DS issue but DS is aborting due to the return code from your RDBMS. One other thing to note too is that if yo...

there is actually only 1 compile. the multiple compiler compiles a number of jobs in a batch, the force will forcefully compile even if there had been no changes and the compile is er..the compile.

as the saying goes "there's many ways to skin a cat". regardless there is still the fundamental issue of "15 days" which ray alluded to. you need to store that information somewhere whether it's in a file and merged back to your input file or a table. thanks for the idea though.i...

You have a data type issue so just do a search on decimal to integer conversion. Also do a search on null fields.

Can anyone plz let me know the method of finding the max input records number using Stage variable only (not using INROWNUM or other ).Please let me know what will be the intial declaration & derivations for stage variables. hi, what is your input ? is that a table or a file or a dataset? perha...

One is that you have to store the date you loaded those records somewhere so you can work out 15 days. If you have that then the easiest way would be an UPDATE job to update the records to E.
Cau you modify the target table to contain a load date column?

Or you could create a remote mounted filesystem on the ETL server that is actually a filesystem on the Oracle server eg. NFS in Solaris. That way you don't have to ftp files/ctl files.

If affinity of job to CPU is what you are trying to accomplish, IBM has the solution for you :) If you use LPARs on an on a Power5 AIX system, you can designate CPU affinity and limit the CPU/Memory resources assigned to a Datastage EE job executing in that LPAR. Never say it Can't be done. Just th...

Simple answer is you can't. It's up to the OS.

Or you could always have a default low value for any null dates
eg. 0001-01-01
provided your application/database allows that.This is similar to how we have high value dates e.g 9999-12-31