DSXchange

You can sort the data and passed it to a Aggregator stage by grouping ID and TERM then defined a calculated field count. Next use a transformer stage [Constraint] to pass the records where Count() > 1

Hi, I want to pass source system as part of the file name. I've defined a job parameter called 'SOURCE_SYSTEM' and assigned value 'TEST'. Then I've entered the following value for File parameter in sequential file stage. File=H:\Project\Work\#SOURCE_SYSTEM#_MASTER.txt I can view data without any iss...

Issue is with Sequencer stage; got the ecase from IBM [ E62595]
Loop fails at the 258 iteration if the loop includes a Sequencer stage (ecase 62595)

Need to download error-free version of vmdsjsgn.dll and compile the job again.

Next stage in this sequence after unix 'sed' command is datastage routine named 'GetJobInfo' . I'm not sure this controller issue coming from that routine. I've handled both triggers [ Failed-[Conditional] and Otherwise ] ; Below code is inside that routone. * Routine : GetJobInfo * Return Job stats...

These are the couple of messages from bottom to top with regarding to issue; Job seq_SP_MONITOR aborted. Attempting to Cleanup after ABORT raised in stage seq_SP_MONITOR..JobControl seq_SP_MONITOR..JobControl (@cmd_sed): Checkpointed execution of command 'sed' seq_SP_MONITOR..JobControl (@cmd_sed): ...

Hi. I've a sequence job which iterates 12 hours to monitor some datastage jobs are executed sucessfully or not. After 30 or 40 minutes job failes with message "Attempting to Cleanup after ABORT raised in stage seq_SP_MONITOR..JobControl". Command executed previous to this message was "...

You can use Surrogate Key stage to generate values by specify the initial value for the key generation. It defaults to 0. You can also specify a job parameter, so the start value can be supplied at run time. If you want to concatenate the generated value with constant, you can use modify stage. In m...

you can use ps -ef unix command to check the processes.
For example , suppose your job name is Job1. Following Unix command will display associated processes with that job.
ps -ef | grep Job1

you can try with following trigger option;
double click Job Activity and goto Triggers tab select the 'custom' option
and enter the correct expression
example :
Job1.$JobStatus<3
Where Job1 is previous Job Activity Name in the sequence.

Empty and Null have different meaning. Most of the cases you need to handle NULL values properly, otherwise it will create so many problems even at run time. You can use NullToValue() function to handle nulls. If your source data type is Numeric you cannot assign non numeric values for those fileds ...

I would like to know answers for following questions.

1. Is your Tgt_StagingArea is a Flat File ?

2. If 'Yes' have you enabled 'output column names' to True ?

If 'Yes' this explains why you got addition record in your output rather than input.

If you can output the material number into a flat file in unix box, you can execute sed command to remove those characters. suppose you have create a flat file (mat.txt) which contains only one column (material num) using following command you can eliminate comma (,) and alpha. e.g sed 's/,$//g' mat...

I think following post you'll get the answer.

viewtopic.php?t=125104&highlight=

I've faced similar errors with lookup stage. Usually this happens when you copy lookup stage from one job and paste it on another job and change the key mappings. Unfortunately .dsx file keeps previous information under binding section of lookup stage. If you really want to remove this message from ...

Define your transforms [ 1..N] in flat files. Example : First file say Transfer_1.txt has following structure FROM_ID TO_ID 100 , 200 200, 300 300 , 400 Second file say Transfer_2.txt has following structure FROM_ID TO_ID 100 , 400 200, 400 300 , 400 So you can pre define those files and use them as...