DSXchange

Is it possible to post the schema you choosed.

Do you use any coustom routine, this segmentation violation most likely to be caused by those programs.

balajisr wrote:

Code: Select all

OConv(IConv(#SYSTEM_DATE#,"Date Format") - 1,"Date Format")

Balaji - Forgot to note? This is PX.

Convert to Julian date which will give you the integer value and subtract 1 and later convert back to required formate of the date.

It seems servername is passed in the place where user name suppose to be passed.

Hi Lokesh, Do you mean to say that you got the same OSH even if you have single key? I make quick test job, sequential file--->sort---->sequential file. I make the key as varchar and sor the similar result as you got. When i turn back to integer it gives in the order. So Perhaps you can look on some...

Source: eno ename sal
1 a 100
2 b 200
3 c 300

Target : field_name data_type length
eno number 10
ename char 2
sal number 10

Jagan has just given sample data for the input and metadata for the target. I dont find any pivoting in this.

Welcome Aboard :D the no. of columns in the source file will become the no. of rows in the target file. Do you really mean to acheive this. I hope you are tyring to import the same structure of the input to the target stage. If so save the input metadata (DS manager can be used). Import back in targ...

You can use IPC Stage to specify that connected active stage should run as seperate processes. You can also use IPC stage between two passive stages to speed up transfer of data between them. Hi balajisr, If suppose one of my process in ETL is taking 3 min to execute and another 20 min, so is it fe...

Validating the job once and running should run smoothly, am I right?

Can you explain bit more detail.

Hi, It is the same as the other programing languages (if you are aware of). Source Code will remain same and single, it is intastantiated multiple time. If it is enalbed with "Allow mutiple instance" you will be given an option to feed in a invocation id while calling the job. And hence if you call ...

It can even speed up if it is conected between two passive stage. Its done by pipeline parallelism. i.e., as soon as the link is open for input to the IPC stage, the output link is also opened parallel, so in SMP or MPP the transfer rate will be more faster. It also enables inter process buffering b...

Since the Chage capture will have both records, in transformer use pivot logic to split the record into two. One to Update link and Another to insert link. Both to the oracle stage.

This is the error code given out from server. But you should be getting some other warning or error which is the actual reason.