DSXchange

Hi Kumar I am working on PX 7.0. I didnt find neither 'Read first n rows' option, nor i found the option File Name Column . Filter command will work on the entire file, but here in my case, I need to convert something like this Column1 Column2 FIlename1 022222222222222222222 222222222222222222211 Fi...

Hi All Please could you suggest me, how to read the FIle(s)name and the first row of that file and then store it into the Oracle table. In Server job, we have source stage which gives us the filename and the entire data of that file. In case I only want the first row of the file instead of the entir...

Is there a way to restirct the seq stage to read only the first record in 7.0 version.Iknow that we have an option in 7.5.1 to do this functionality(Number of records). If not, wats the best possible way ?Be'coz i don't want to read the whole file but process only the first record. Thanks for ur hel...

Currently,we have an application that is bulit using Datastage.Most of the jobs do the aggregation on different levels(grouping elements) to the incoming data and loads it to the tables.The whole of the process takes around 45 mins for 120,000 records. We are thinking of moving the aggregation opera...

All, one of my PX job( Which is triggering INSERT query) failing frequently by saying sqlcode is: -60 esql complaint: ORA-00060: deadlock detected while waiting for resource it's happening regularly on a particular table... I want to confirm the issue is really with ORACLE or is it due to the parall...

Thanks very much Ray! Routine activity invoking UtilityAbortToLog will abort the main sequence. But it will not send stop notifications to currently running jobs. This is working good! and I can have Routine activity invoking UtilityAbortToLog in the Failed Link and the trigger as OK(Green) link to ...

Ray..Thanks again! but the Exception handler is not aborting the Sequence ( it just stoping from running further) I am using PX 7.0 ( NO Terminator activity :( ) My requirement is Under sequence S1,i have Jobactivity1-->if ok--->jobactivity2--->if ok---->job activity3 ...etc... If any jobactivity fa...

Thanks Ray & William! Sorry for the delayed acknowledgement! ________________________________ About using notification activity ------------------------------------ As you have mentioned, I was using the Exception Handler. as we found in documents,It's just stoping the main sequence from running...

Hi All, I have 70 parallel Jobs which is arranged under 5+ sequences( 3 levels of hierarchey) and I scheduled all jobs once in an hour thru a Unix script scheduler If suppose some of my job failed, The sequence which is having that particualr job aborted on the next time run(next hour), and the Sequ...

Hi All, Recently we have decided to move our project which was developed and running in PX 7.0 to PX7.5. Is there any major impact's on this move? I heard that PX 7.5 have different kind of lookup stage then PX7.0. Do we need to take care anything spcifically on this or all the jobs will run asusual...

Hi All, We are trying to use some Java EJB programs in our PX. Any of us have any Idea about the plugins which I need to use to do this or any other specific IDea's? In my RTI Palette I have only MQ plugin and XML plugin nothing else., Thanks in advance. Edi Thanks for ur replies.Let me explain you...

Hi All,

We are trying to use some Java EJB programs in our PX.
Any of us have any Idea about the plugins which I need to use to do this or any other specific IDea's? In my RTI Palette I have only MQ plugin and XML plugin nothing else.,

Thanks in advance.
Edi

Hi All, We started receiving some flat file inputs without any delimiter on it. (continious stream of charecters) We need to split into columns based on the charecter position in the paricular row. (for ex, char 1 to 10 Column1,char 11 to 15 column2..etc....) which stage will be most appropriate to ...

Due to the deadlines,we had only limited time for analysis...
we tried all the options..
The Re-import of the DSX solved this issue.

Thanks Ray..Kumar.

Edi.

Hi All, While we are moving the JOB to a Proteted box( i.e DEV to PROD) one of the JOB aborted with the below fatel error. we are using the same version of PX 7.0 on both the enviorunments. any valuable Inputs on this? "FormatTextLine: Failed to load the library "V0S10_jbBuildGMRDMailForSe...