DSXchange

Hi, I created a Job whose flow is as below: FileSet Stage (Output columns A,B,C,D,E) -> Transformer1 (o/p cols A,B,C) -> Lookup (O/p columns A,B,C) -> Transformer2 (o/p Cols A1, B1, D,E) -> Change Capture (O/p cols A1,B1,D,E) -> Sequential file (Cols A1,B1,D,E) It was giving me following Fatal error...

Hi Vitali,
Thanks for your time.

Actually I'm new to DataStage.
Can you please tell me in detail, where do i give mybuildop -myparam
and where and how do i give $argument directive?

Thanks & Regards
Pinkesh

Hi,
It is required to pass a Job parameter to BuildOp Stage. Any prompt help in this regard is highly appreciated.

Thanks & Regards
Pinkesh

Hi All, Pls clarify me the difference between Scratch Space and Temporary Storage Space. Does Temporary Space includes scratch space? Or they are mutually exculsive? I think we have to specify scratch space for each node. But does this mean that that scratch space will be present in Temporary Storag...

Hi,
What is the Scratch Space required to read a file? If I am having a file set having size 30GB, what will be the size required for scratch space?

Pls let me know what is the raltion between File Size and Scratch Space?

Thanks & Regards

Pinkesh

Hi Ray, Thanks for your time. Actually, in one job I'm running a extraction command. That command writes the status on to the terminal. That status I have to capture ans send it to next job. Basically, that extraction command will invoke a tool to get the data from a table and returns the output (on...

Hi All, I have to check for the Temporary Storage space that will be required to run the jobs. I have around 10 Modules that will concurrently start running. Each module is taking records (in Millions...max 3.7 billion) as input in the fileset. So for this I have to decide for the temporary space re...

Hi,
I've created a Job sequencer job to control the flow of jobs. I am getting an output value in one job. I have to pass that as the parameter to next job.
How do I do that? Any pointer to this please.

Thanks & Regards
Pinkesh

Thanks a Lot for your suggestions & time.

Regards
Pinkesh

Hi All, Is there any pointer to see the common precautions/errors that can occur while migrating from DS Version 6.1 to DS Version 7.0? In Ver 6.1 i exportd all the jobs. And now I've migrated to Ver 7.0 and imported all my jobs. I'm facing a problem in one of my job which uses Change Capture Stage....

Hi All, At some point of time, I lost the connectivity to the DS Server. When I got the connectivity, I could not open the project. It gave me following error: ACCESS DENIED: Project currently locked. Project is currently locked by the Administrator. Once i was able to connect to Designer. But when ...

Hi, Thanks for your suggestions and time. I tried both the options i.e. Compressing a file and using a Fileset. Problem with Compress stage is that it needs minimum 1 output stream. I could not find a stage that can hold the output of Compress Stage (i.e. data in zipped format) Problem with fileset ...

Hi All, I'm getting a compilation error while compiling a job. It was working fine till yesterday. But now it is giving an error "Error Writing to RT_CONFIG143". On "Show Error" it gives the following message: "(40908) A request for an object with NULL ID was made." Cou...

Hi All, Can we read from a named pipe in a parallel job? I have seen that in Sequential file stage of server jobs, there is a check box for specifying that data has to be read using named pipes. Is there anything equivalent to this available in Parallel jobs? Also, we are planning to migrating to DS...

Hi All, It is required to read from a file set, do some trasformations and send the final output in a file to third party. The output can be bigger that 2GB but as we have a Operating System restriction of file size can't be greater than 2GB, i was wondering in what format we can have the output and...