DSXchange

As usual agreeing with Ken.

Another advantage of separating deletion of the staging data from the job that uses them is that you get easier restartability in the event that the job fails to complete successfully.

Modularity, I guess.

Hi Vincent, The shared container is being used in colse to 50 different server Jobs having diffirent number and type of columns. Because of this its not possible to pass all the columns through the container. Is there any way in which I can pass all the columns through the container. That would def...

yeah... i am not not trying to either buy or use it now. :D .. i am just curious... wht makes it different from server jobs and what will be the criteria to choose between server and parallel jobs.. i know everything (tool supported processses)can be done with server jobs... it this vice versa Ever...

As I understood, I would be able in the same job write to multiple tables for same schema and create FK? Is it correct? Basically this is correct, you can. But best practice is to load the operational master (dimension table) first, then to load the operational detail (fact table). In this way you ...

Shell scripts in every shell I've dealt with recognize positional arguments through the shell variables $0 (the script name), $1, $2 and so on. Some shells are limited to ten such arguments, which you have to get around using shift. But, since you only need three, this ought not to be a problem. Why...

Hi, IMHO DWHs are not something you have FK constraints on (period) and expect loading performance. your ETL should have integrity checks for that and the DWH should be free of such things (correct me if I'm wrong people). now if you insist on having FK constraints then do it the slow sequential wa...

I am having trouble with a date conversion. It's in the format MMDDYYYY and is being converted from EBCIDIC to ASCII, but then I need to write it to an Oracle table, which expects it in Oracle 'date' format - MM/DD/YYYY. My problem is some of the dates are null. This wasn't a problem converting fro...

The annotation number (the "An" part of the internal identifier) relates to the order in which annotations are added to the job. So I'm not really clear why you want to "assign" "V0A0". Can you be more specific about what it is you're trying to do? DS_JOBOBJECTS is indexed on OBJID (that is, the mid...

Just to make it clear, Parallel Extender is an additional cost, and not (yet) available for the Windows environment. Parallel Extender does more than allow DataStage to run parallel jobs. It becomes part of the underlying architecture so, for example, INTEGRITY (now Quality Stage) processes can also...

Can't do it from a before-job routine, because this runs as part of the job itself, and parameter values can't be changed once a job is running.
Can do it from a controlling job.

Are you running out of disk space on any of your processing nodes?

Please share with us any solution that you find. You never know, you might develop some insight that has bypassed us all! :D

Ah. I'd assumed (always dangerous, that) that your regional settings were already correctly set. Good lesson, another thing always to check.

Ray, out of curiousity - how does one go about maintaining these 'paragraphs' if you start using them? Get a listing, edit, delete, that kind of thing... Thanks. Each paragraph is stored in the VOC file with a TYPE of "PA". But there are more paragraphs than yours - there are quite a few that DataS...

If you're using a BASIC Transformer stage (or are in a server job), you can use a BASIC expression. The easiest way is to perform some arithmetic. But you have to be certain that what you're beginning with can be regarded as numeric. If Num(inlink.column) Then Iconv(inlink.column,"M...