DSXchange

User id you are using is having permission issues.

ArijitS wrote: Access is denied.

The Join stage requires inputs to be identically partitioned and sorted on the join keys, mainly for efficient memory management and quick processing. The data sets input to the Join stage must be key partitioned and sorted. This ensures that rows with the same key column values are located in the s...

Use modify stage. There is a function - 'string_trim' (Ref. Orchestrate Operators guide 7.5 version) which can be used in modify stage to trim string. But you cannot trim both leading and trailing spaces using this function. This is the syntax : string_trim[character,direction,justify](string) This ...

Did you try? Sed is an Unix command, you will find details about that command if you search. Above code will remove the first and last line from the input stream feeding to datastage.

Refer THIS link.

Set the APT_PAD_CHARACTER to space, then trim on both links for key fields to join and try.

In the 'filter' option of your sequential file stage use the below code and try

ORA-00907: missing right parenthesis

Cause: A left parenthesis has been entered without a closing right parenthesis, or extra information was contained in the parentheses. All parentheses must be entered in pairs.

Action: Correct the syntax and retry the statement.

You can do this in many ways.
Pls. refer THIS post for one way of doing it.

You might want to use Surrogate Key Generator after Change Capture Stage. But What if I do not want this. This field is required to be populated in the target table, but since it is generated from a Surrogate Key Generator, I can not calculate a change on it also it can not be defined as a key as I ...

By default there is a record size limit in datastage. Pls. refer HERE Check the file size in the sequence job just before calling your main job and if your expectation doesn't match don't call the processing job, loop back . I am having a file of length 800, if the record size is above 800 i need to...

Right click and you will get the option for this.

Poornagirija wrote: I tried user variable stage but iam not able to add var.its not showing any add button.

No limits

But my question is like how to make this as generic in sequencer...
if there is any limit of passing the values to parameters..

Byte Kilobyte Megabyte

And what all are the error handling options you have set / checked in your job parameter tab?

dnat wrote: In Job activity 1, i have given the trigger as unconditional.

But, the problem is, if Job activity 1 aborts while processing the file, the whole sequencer aborts.