DSXchange

Hello, My job have the follow configuration: ORAOCI8 ----------------->TransFormer------------------->ORAOCI8 select * from table A insert into table A ... where rownum< 1000 Rows per transaction=1 If i had that configuration the job run ok, but take long time because the "Rows per transaction" set ...

I am trying to move Oracle Long and Long Raw columns using DataStage v5.1. In both cases DataStage aborts, reporting Oracle datatype not presently supported. Has anyone experienced these problems, and if you did how did you get around them? Does anyone know when DataStage will support Oracle Long da...

Looking on this page makes me think, that some Ascential-people seem not to be aware, that there is civilized life even outside the borders of the United States. There are since several years DataStage-User-Groups in the french-speaking part of Europe and in the german-speaking part of Europe and pr...

ASCENTIAL USER GROUPS - MEET AND NETWORK WITH OTHER DATASTAGE AND INTEGRITY USERS IN YOUR LOCAL AREA Are you eager to share productivity tips and tricks, discuss DataStage, INTEGRITY and MetaRecon product direction, and learn about hot market trends that will help you improve your business? Are you ...

I forget to write that you have to uncheck the CLEAR FILE BEFORE UPDATE... option Riccardo ----- Original Message ----- From: "Paul Ko" To: Sent: Wednesday, July 10, 2002 1:16 AM Subject: Initializing hash files > Hello, > > I have a very simple job. The intention of the job is to initialize a hash ...

We have implemented a few hashed files where there are millions of rows, but only one or two columns. They FLY for key-based lookups, particularly when pre-loaded into memory.

How about an ODBC stage with user-defined SQL such as SELECT MAX(KEYVALUE) FROM TABLENAME as its query? Load this value into a one row, two column hashed file, and use the other (constant, key) column of the hashed file for a reference lookup. Enrol on "DataStage Best Practices" to learn ways to man...

CLEAR.FILE is definitely not the recommended way to clear a job log. This method can lead to errors ("cannot find event number 0") and will destroy job-specific purge settings, etc., which are stored in control records in the job log itself. You need three steps: (a) clear just those entries with a ...

John Whyman has in the past posted what is probably the fastest techique; initialize an array of 256 values containing the corresponding PC100-ISOLATINE1 code point for each ASCII SEQ() value. The required value is then simply an index into the array based on the SEQ value of the corresponding input...

Hi, There will be a problem using the DataStage sequence generator if u have multiple Projects trying to use the same oracle table to insert the records, as the DataStage sequence generator starts from 1 in each project and there will be an ID clash. regards, Aedla. -----Original Message----- From: ...

Raymond and Chris, thanks for your valuable information. Best Regards, Susan S. Chris Kearns cc: Subject: Re: Moving Datastage ETL log file location 10-Jul-2002 06:19 AM Please respond to datastage-use rs Sender Info: No Sender Info found in the address Book If disk space is an issue, you may want t...

I think that it may have something to do with the constraint that you are trying to apply. Regards, Damien -----Original Message----- From: Paul Ko [mailto:paul.ko@team.telstraclear.co.nz] Sent: Wednesday, 10 July 2002 12:20 PM To: datastage-users@oliver.com Subject: RE: Initializing hash files Hi K...

Paul, the job is doing exactly what it should be doing. DataStages first task on a job run is to verify targets. If the target is a hash file, it then verifies that it can open it. If it cant, it then checks if the create file option is checked and then creates its. Once open, if the clear hash file...

Hi Kavney, What I have observed is that whenever the check box for CREATE FILE is on, it will perform a cleanup of the hash prior to any processing. See log below: 14:09:08 10/07/02 Control Starting Job InitAccount. 14:09:09 10/07/02 Control InitAccount.TRANSFORM_01: DSD.StageRun Active stage starti...

Paul, What happens when you run the job without the option of Clear the Hashfile before update. Regards, Damien Kavney MIS Technical Support Department Of Natural Resources & Mines PH: 38963989 -----Original Message----- From: Paul Ko [mailto:paul.ko@team.telstraclear.co.nz] Sent: Wednesday, 10 July...