DSXchange

Can any one suggest what is the solution for this issue?

Hi , looks like no issue in the code. here are the things - I am running my jobs on grid environment. - getting data from oracle database. - lookup with db2 database based on the key. - using transwarmenr loading data into oracle table. This is the code. if I run the job it is running 3 min. and abo...

No mostly the design is look up for the data and giving input to shared container and inserting or updating to the database.

Hi , When I run the job I am getting the following error "Operator terminated abnormally: received signal SIGSEGV" my database connections are good. it is running 3 minutes and after that my job is aboring with the above error. can any one suggest me please. I am hoping its memory error, s...

As per my knowledge , we can do in informatica. but we need to create two tables and we need to set the properties to session and workflow. I did't know the table names. if the session abort , it will re run the process in recovery mode. if the commit intervell is 2000 and job fail at 2050 , in the ...

Restartability of job sequencer can do by doing the check point.

but my question is how to start the loading process from the failure process, which means from the last commit.

We are not using any scheduling tool. I am running the job sequencer through datastage director.

We have functionality in Datastage. to restart the process from the abort point. But I don't know exactly how to do that

Hi, Need your help I have one sequencer, it have 5 job activities and the 3rd job get failed. The data volume is huge , job get aborted after 2 m records. I want to restart the sequencer from that failure position. Which means from 3rd job activity should start and start load from 2 m record. We are...

Hi, small update . If I run the job I can see the logs. but by after noon or next day logs are missing and in the menu--view we did not set any filter.

Hi I am running datastage job , but I can't see any log message from datastage director. Any help please

i am trying to select the data from various tables from db2 data .when i run the jobs i am getting the following error.it used to work fine for one constrain. If I run for all I am getting the error.please let me know if any issue with the fix pack . Please find the error message We are using DB2 9....

Check the input properties of the transformers, there is option of partitioning, in that there is option of sort 1. Stable :- This is for previously sorted datasets.. 2. Uniq :- This will retain only first record if there are duplicates on the sorting key values. hope this helps ----------------- M...

Hi,
How to sort the data using datastage without using sort stage?

Can any one tell me how to use the UNIX sort commond in transformer?

I am using Datastage 8 version and HP unix.

Thanks in advance.

I am writing into file.

Hi Can you try with the follwoing formate

Oconv(Iconv(DSLink3.FieldName,"D-DMY[2,3,2]"),"D/DMY[2,2,2]") Or

Oconv(Iconv(DSLink3.HIREDATE,"D DMY[2,3,2]"),"D/DMY[2,2,2]")