DSXchange

Hi I got the following error while extracting data from a table and insering in to the hash file. in Select statement we have 7 fields. while creating hash file we are keeping 6 fields as a key column. Kindly give me your valuable suggestions to fix the job. LkFBLk..FormatKey: ORA-12801: error signa...

Hi, We have observed below data order in the data when it is written to output file. This is a server job. Could anyone please explain. We have input data order as mentioned below. ID|NAME 1|A 2|B 3|C 4|D Job is very simple and no contraints involved. In output file, the data order should be same as...

Hi,

I have a requirement as mentioned below. I need to split one record into multiple columns as shown below.

Input Record
---------------
Col1
a,b,c,d
d,e
f,g,h

Col1|Col2|Col3|Col4
a|b|c|d
d|e
f|g|h

Could anyone help me out on the above.

Thanks in advance.

Regards,
Raj

Hi,

I have a requirement. I have to add 91 days for the below date format. Output also should remain same.

Input--> January 6, 2008

I went through the forum, but I am not successful.

Can anybody suggest the solution.

Thanks.

Hi, I am trying to run a job but this is aborting with error in the log "Abnormal termination of stage ********** detected. I reset the job and see the same error without much help. Error: "Abnormal termination of stage LoadsCausalStageSchema..Xfm detected" Job Design: Iam loading dat...

How can this be done? Can you please quote an example?

Thanks for your reply.

Iam aware of that option, but my requirment is to parametarize it. Please let me know how can this be achieved.

Regards,
Rajendhar

Hi, I have a job which loads data based on a user defined SQL into target table. Since this job is called by 2 different sequences which run in parellel, I have checked the "Allow Multiple Instance" checkbox both at job level and sequence level. When I click on the run button I need to man...

In Datastage % equal to ...

Hi, I have a sequence like this. JobActivity --> Routine Activity JobActivity calls a simple job. Job Output will be written to a textfile. Routine Activity calls a custom routine i.e. reads the ouput of step 1 text file. The two output possibilities of textfile is 1) it may have empty data 2) it ma...

One option is go to 'task manager' --> process --> cmd.exe

Kill the processess which are running with cmd.exe. Continue this till whole job is stopped.

Hi,

We have an urgent requirement that we have to read a COBOL definition file using server jobs or parallel jobs.

Is it possible to read data using CFF stage. If yes, could anybody please elaborate more on this.

Thanks..

Hi, I have some data. Following is sample data. A|B|C --> First line is column header 10|24|35 4|8|NA 98|23|NA 25|83|17 In above sample data all 3 columns are INTEGER datatype. But C column is having NA records. When I read these data through sequential file stage the bad records get rejected (i.e. ...

Hi, Since delete is very costly statement, one option to solve the issue is, 1. Load the required data(remaining 370 M records) to a TEMP table. 2. Truncate (or) drop the main table. Following command can be used to truncate the table. This is very fastest method. ALTER TABLE <SCHEMA.TABLENAME> ACTI...

Hi, We have developed all jobs in Datastage 7.5.1(server edition) in windows server. Is it possible to migrate the jobs to Datastage 8.1 (parallel edition) in LINUX server. Since it is a different version, will there be any compatability issue. If it is there how do we take care of compatability iss...