DSXchange

Hi, I have a simple job that reads from my date dimension and writes into a hash file. One of the fields of Date datatype is read as a timestamp in my oracle connector using the mask YYYY-MM-DD HH24:MI:SS. I'd expect the timestamp to read something like 2014-06-11 00:00:00 But when I see the hash fi...

FYI, the Copy Stage will not get optimized out during compilation but only after the score is composed which is post job run. Now that you mention that you ran the job and the score still contains the copy operator, remember that by setting the option to 'false' you are giving the optimizer an optio...

Try running the job and check the job score (set APT_DUMP_SCORE environment variable) to see if the copy operator appears there

Thanks Craig.
The error I was getting was because of incorrect bind variables and not because of the comma. Got through it. Thank you

Hi, We have an Oracle stage with a custom insert SQL. To fulfill some requirements, we are modifying the insert to include a function so that my insert will look something like : INSERT INTO XYZ_EDI_852_DLY_FACT (EDI_SNDR_KEY,......,BU_CODE,OPER_WK_END_DT) VALUES (:1,...., GET_BU_CODE_X(:11,:2),GET_...

Thank you Ray for taking time to answer my query. Agreed. The dummy job stage is really not required. Here is the updated design. The nested condition stage would trigger 2 links as mentioned in my earlier post. I think that this would trigger the actual_sequence for different BUs in parallel albeit...

Then the processing would become sequential. Here, the dummy job(which would basically do nothing) would run as part of the loop in every iteration. On successful completion, the dummy job will trigger the 2 subsequent links - the actual_sequence with eh start loop counter variable as a parameter an...

Hi, We have a set of multi-instance jobs that form a master sequencer. These jobs currently process data for multiple business units(BU) at one go. We are trying to separate the process for each BU and have them run in parallel through the same existing logic. The names and number of BUs will decrea...

Hi, We have a job that looks up from the same table that the job is loading into. Something like this. Table A | | | Hash File | | SrcFile---->Transformer-------->Table A Is this a good/correct practice? Won't the target keep changing even while it is being used as reference due to the pipe-lining o...

Hi, I am currently reviewing some decade old server jobs. Having worked with parallel jobs all the while, I'm running into a few conceptual road-blocks. Please help me understand the following: 1. There's a job that uses a Universe table as a reference for a lookup. Why and why not a hash file? 2. W...

What else?

Hi, We are in the process of defining a framework through which each of our DataStage jobs should flow through before finally executing. What are the things to look out for while defining such a framework? For starters, I am planning to check for other instances of the same job with the same invocat...

What have you tried? Did you read through the parallel developers guide?

Hi,
I think the Change Capture Stage would serve your purpose. Suggest using the Checksum approach if you are dealing with huge reference data.

I don't think FastTrack is yet capable of generating complex jobs. FastTrack would be able to generate fairly straight forward jobs. Why don't you check it for yourself? Would definitely love to be proved wrong