DSXchange

Make sure also that the execution mode of the Sequential File stage is sequential, not parallel Ray, does a sequential file stage support Parallel execution mode? I've never seen this option changeable - it's always greyed out (no-change mode) in all the sequential file stages used in my project. D...

Helpful article: Is DS Parallel Transformer Evil?

Vincent quotes "Over my years of using parallel jobs I haven't noticed that much of an overhead and when you use the transformer for several tasks (transform, filter and copy) it can be faster."

If you are on v7.5.1a or above, I'd personally go for single Transformer stage rather than using Modify plus Filter.

Btw, it's no more called HAWK. It has been officially named as DataStage 8.0

jhmckeever, Thanks alot for the advice.. It worked!!! I did a Force Compile and the job runs successfully. I am wondering why a simple compile didn't actually compile the job?! Btw, we have many transformer stages in the job and we changed our APT config file recently. All other jobs were running fi...

Yes, the job gets compiled without failing, it throws error during its execution.

samsuf2002,

As I mentioned, a copy (Saved As) of the same job is running fine!!

Hi All, One of my jobs is failing with Fatals as follows: --------------------------------------- tfp_individual_details: Failed to load the library "V0S536_djp_Individual_Dimension_tfp_individual_details.o"; either the directory containing the library file is not on the library search pat...

Alternatively, you can fire the same command on TCL prompt. Do a search in the forum for detailed info.

I have opened a case with IBM. Let's see what they have to say.
Will update this thread once hear from 'em.

Hi,

In Director, one of my jobs shows status as 'Finished'. When I open the log I find lotsa Fatal messages. I was under impression that if the log has even a single Fatal, the status of the job would become 'Aborted'.

Any explanations?

Thanks in advance!

As said by Kumar, ETL ends at loading the data into a database called as data warehouse. But what's the use of data when it cannot be converted as information! DW includes ETL plus reporting for analysis (in most cases). People usually go for OLAP tools like Cognos, Business Objects for reporting pu...

Nagesh, As mentioned by you, the same set of jobs are running fine in DEV env but failing in UAT. I suggest you try to figure out if there is any significant diff in the cofiguration (DS, OS and DB) betn the two environment. Monitor the resource usage while running your jobs. As mentioned by Kumar, ...

How about counting the number of lines in .dsx file? Just a thought! Next questions that might come up are.. What components to export? Full export or job designs only? Are we really measuring the work done (resource spent) based on this number? I know, it's not et al intelligent, but I need to prov...

Kim, Thanks alot for providing the SQLs. Answering to Mike, it's a policy in my organization to collect number of lines of code used in all the projects. This is basically to measure how much coding has been done. Unfortunately (or fortunately :wink: ) DS doesn't have code in lines. So we thought of...