DSXchange

In that case, dont use a lookup. Reference the sequence in the INSERT statement (refer my earlier post). -----Original Message----- From: Wilcy William [mailto:wilcy@rediffmail.com] Sent: Thursday, 24 July 2003 1:38 AM To: datastage-users@oliver.com Subject: Re: Re: Sequence generator The changes ar...

I meant that i cant figure out the problem. what does the composite operator do? -----Original Message----- From: Babatunde.Ebohon Sent: Tuesday, July 22, 2003 3:08 PM To: datastage-users@oliver.com Subject: PX Error does anyone knows what this error is? I can figure it out. its a PX error. mzrt_inv...

The changes are 1)We were inserting the rejects into a flat file and now we are using an Oracle table 2)We are using a Oracle sequence The SELECT is used on a reference input link . On Wed, 23 Jul 2003 Ray Wurlod wrote : >Has the design changed between getting 3000 rows/sec and getting >300? >If not...

Wilcy You do not need to store it between runs. Just select max(Key) from TargetTable; into a hash file at the start of the job or in a job before this job. You can lookup this value in a reference lookup or in a routine. Thanks Kim. Kim Duke DwNav - Navigate ETL Business Rules www.Duke-Consulting.c...

I ran a copy of the job without the Oracle sequence and it ran much faster. After adding the Oracle sequence it reduced to 1/10th of the original speed. On Wed, 23 Jul 2003 Craig_Hulett@rsausa.com wrote : >First off, are you sure your sequence generator query is the >source of >your slowdown? There ...

This is a topic for an orphaned message.

We need a hash file to store the last value of the sequence so that we can use it in the next run. With regards, Wilcy On Wed, 23 Jul 2003 Tony Stark wrote : >Hi Wilcy, > >I understand that a DataStage Sequence may not be >appropriate under all circumstances with Oracle >tables, but I am not sure wh...

Have you tried : Oconv(@DATE, "D-YMD[4,2,2]") : " " : Oconv(@TIME,"MTS") (field type is timestamp, lenght 19) @DATE and @TIME are the jobs start date and time, they remain the same during all the jobs execution. This works well on traditionnal server jobs. Cant say for PX. Regards, Erwan >>> Babatun...

Hi all,
Does anyone know how to generate a system date on PX? Im trying to populate a field with the system date and i cant seem to find any funtion to give me an oracle compatible date. Not even TimeDate[].
pls help.

Tunde

I assume that you are using this as a lookup and need to use the returned value in more than one part of your job. If not, can I suggest that you put the sequence in the OCI that you are using to insert the data in the first place. Also recommend that you cache X thousand records of the sequence in ...

What about PX? Does anyone know what the best practice is to Generate sequence? -----Original Message----- From: Tony Stark [mailto:tonystark622@yahoo.com] Sent: Tuesday, July 22, 2003 3:49 PM To: datastage-users@oliver.com Subject: Re: Sequence generator Depending on your needs, DataStage has its o...

Yeah, I knew that it used SDKSequences, but, as you stated, its all behind the scenes and shouldnt affect the job design. Tony --- Ray Wurlod wrote: > Tony, > > Check out the code for KeyMgtGetNextValue; it > creates its own hashed file called SDK.SEQUENCES > (iirc). > > Wilcy, > > Why do you state ...

Has the design changed between getting 3000 rows/sec and getting 300? If not, what has changed? "Nothing" is not an acceptable answer. For example, if the target table was initially empty and is now huge, and youre using update or insert as the update strategy, this would explain some degradation of...

Tony, Check out the code for KeyMgtGetNextValue; it creates its own hashed file called SDK.SEQUENCES (iirc). Wilcy, Why do you state that using a hashed file is not possible in your situation? The hashed file is completely transparent to the job design. Regards, Ray ----- Original Message ----- From...

Hi Wilcy, I understand that a DataStage Sequence may not be appropriate under all circumstances with Oracle tables, but I am not sure why you say that KeyMgtGetNextValue requires a hash file. I have used this transform/routine several times in the derivation column of a transformer stage with no has...