DSXchange

Hi, i use datastge 5.1 with an Oracle DB. I have an implementation problem. Now the job is composed by a source plug_in (where there is "new value from source"), a lookup plug in (where it is possible to find the "old value" if exist) and a destination plug_in. If the lookup join...

Hi Kim, what are HASH.HELP and ANALYZE.FILE exactly? Where i can find it? I created the hash file with the command produced by HFC.EXE I calculated the average length of a record and i used "no dicernable pattern" in the key pattern. The other option was modulo style= prime number structur...

You can use the function "Trim" in the rigth side of trasformer. Mario quote: Originally posted by sweetleaf [br]Hi there, Is there an equivalent to vb or oracle TRIM function in DataStage? I have a seqential file stage connected to one transform, then 2 output links from the transform sta...

Hi, i did some test to compare the performance of 32 bit Hash file VS 64 bit Hash File on a HP server. The test consists of: a flat file (with 1400595 records), an hash file (with 1400595 records) an another hash file with the join of the records ( flat file --- | |------> join -----> write hash fil...

Hi, i have a job that uses some hash files. The hash file's load process is performed by a different job. The job that creates the hash file ends with this message: File '/tmp/EBIS/F_NORMALISED_EVENT_HSH_Adc/DATA.30': Computed blink of 0x974 does not match expected blink of 0x0! Detected within grou...

Hi, i have a problem with the Hash File. Sometime go i posted a problem about the limit of the dimension (over 2GB) and someone told to use the HFC application in the DataStage CD. I tried to set this parameters: File name: FILE key pattern: No discernable pattern Average record(byte): 500 Number of...

Hi,
the true problem is that i haven't the Administrator's password.
Does an another way exist to unlock the job?

thanks

Hi, we have a problem with a job. when I work with the job the network goes down and now it is impossible to access it. I know that if I restart the server is possible tho unlock the job but now is impossible to do because some other jobs are running. Does a method exist to unlock the job? In DataSt...

Hi, i use DataStage in a Sun server. The data load uses several jobs with this steps: 1) read the data from a remote db and creation of an hash file. During this step the job reads 27.000.000 of record from a remote dband all work fine. 2)The next job should read that hash file but Datastage aborts ...

Hi my problem is this : I must load a large volumes of data from a flat file into an Oracle Table directly (without a transformer stage) like this : [FLAT FILE]-------------------->[OCI8] I try to use an Oracle HINT directive into the Before page and into the SQL-User Defined page of stage: [BEFORE ...

Hi chulett, i need a query user defined where the query must change between a run of the job and an another. A possible solution is to define a job's parameter with the query. The size of 30 KB is because the the max size of a varchar2 variable in PL/SQL is 32 KB. Mario quote: Originally posted by c...

Hi,
i need to know how many characters (byte) are the max lenght of a Job's parameter (String).
Is it possible to use a different datatype longer than string for a very large parameter (approssimatively 30 Kb)?

thanks

Mario Loreti