DSXchange

Transformer:StringToDate(lkup_cust_out.OHEDAT,"%yyyy-%mm-%dd")-- Output is *********.



In The Transformer, the following works.

StringToDate(lkup_cust_out.OHEDAT,"%yyyy%mm%dd") unless the supplied date is invalid like 20060500 Or 20060005

is there any particular stage to extract data from postgresql
Thanks in advance

what happens if it has a value like 00000000.00, it might end up like .00 when we use Trim("00000000","0","L")

Table is not partitioned and the Primary Key index is also not global.

Do we really need to partition the data before loading into Oracle when ever there is a primary key index. Is it a regular practice or does Datastage automatically handles such type of situations. The partition i am using is Auto and the data was not partitioned. Upsertmode is Insert then Update ( c...

Do we need to repartition the data before loading to a table based on the columns which constitutes a primary key on the table. I am getting the following error. PROCESS_AUDIT_PARAMETERS,1: Array execute failed for insert: insert is: INSERT INTO FDW_PROCESS_AUDIT_PARAMETERS (NM, VAL, PRCS_AUD_ID) VA...

The fields we were using are Decimals ( In Oracle they were defined as Numbers, so by default it is treating them as Decimal (38,10) ). Besides these we have a total of 300+ input fields & nearly 30+ million records. We had all kinds of troubles before splitting the stage variables among multipl...

Thank you for sharing your ideas

Hi us1aslam1us,

Can you explain briefly what happens when we use multiple active stages without having any dummy stages in between.

For example, i need to extract data based on keys which i cannot use them in one lookup stage or join stage. Don't we run out of memory.

I donot have the log now, one of my friend is using 60+ stage variables in one transformer, then we split them by adding two more transformers. It worked fine later.

Instead of using the Job Parameter, try GetEnvironment($Parameter) and delete dollar sign. It worked for me.

How many stage variables one can use in one transformer, i had a case where i am using 40+ stage variables.I got compilation errors then i used two tarnsformers(with 20 stage variables each) with a copy stage in between. Can i use back to back trasformers(or Active stages like Lookup,Join) with out ...

I didnot put two triggers from Job2, these are two sequence activities one on both side for success of all jobs or failure of any job.

<< --- Job1--->> Seq(Any) <<---Job2--->> Seq(ALL) --->SUCESS (Notification) <<---Job3--->> FAILURE (Notification) ---->> ABORT( Sets the Sequencer status to Abort) If Job2 Failed, i don't want to stop the Jobs 1 & 3 and my sequncer should get the status Abort (3 for abort). So when i run restart...

We are trying to kick of three different jobs(Job Sequencers) parallaly with the help of a Job Sequencer. There are two Sequence Job activities one with ANY and other with ALL types and two notification activities which sends mails upon success or failure of any three activities. Here we are suppose...