DSXchange

loveojha2

Do search your hashed file in VOC using

SELECT COUNT(*) FROM VOC WHERE TYPE='F' and NAME='Hashedfilename'

if it returns 1 then the Hasehd file is existing else create one using the

Code: Select all

CREATE.FILE filename DYNAMIC

may be (using Create table command also)

loveojha2

Do an exact search on ETLStats.
It is very good bunch of tools for the things that you are looking for, posted by our own ETL stat guru Kim Duke.

loveojha2

My conclusion is that when you have created a hashed file and you want to use this hashed file in different jobs you need to use the complete layout of this hashed file. Not Always Dropping columns is not recommendable. Hashed files are not 'column driven'. Is that correct? There is no such restric...

loveojha2

Does

Code: Select all

DELETE.FILE X

rescue.

loveojha2

Create one more link to the target from the same transformer and send the changed row only after you recieve the new row through this link and the other link would be sending the row if the row is not to be changed. Although it is not the exact solution but it should give you the outline of how to p...

loveojha2

What about

Code: Select all

Value/1000

Guessing if your data is 999999 then you want 999.999

loveojha2 · Code: Select all `SELECT * FROM DS_AUDIT WHERE DTC> '2005-01-01' AND CLASS='2'`

Code: Select all

SELECT * FROM DS_AUDIT WHERE DTC> '2005-01-01' AND CLASS='2'

loveojha2

Dump the data into the Sequential file instead of the the db stage and see if it affects the timing (and by what factor).

That way you would be sure of the problematic area to look for, either the source or target.

Is there any chance of any other process having locks on the same table?

loveojha2

I am kind of confused with your post about the content of the Hashed File, are you saying that your Hashed File is actually having the exchange rate? If yes, then it's a lookup. (I guess this is what your case is) If it is containing the data to be converted then it has to be processed for each row....

loveojha2

Due to my data is more than 6 millions records....is it suitable to use sequential file? Sequential files are best suited if the processing requirement requires every record to be processed. Whereas Index Files (including the Hashed indexed ones) are suitable where requirement is faster random proc...

loveojha2

For jobnames you can use

Code: Select all

SELECT NAME FROM DS_JOBS WHERE NAME NOT LIKE '\\%'

You can use it inside the Universe Stage.

loveojha2

You can use

DSGetJobInfo (JobHandle, DSJ.JOBSTATUS)

for the user status. But prior to this you would need to get the handle of the job and after this you would need to release the handle.

loveojha2

I thought I would still be able to access DataStage since the Everyone/DataStage Developer permissions was still there but now I get a log in error trying to launch designer. Even I think so, you should be able to login to the server since it is granted to everyone. Are you using omit option while ...

loveojha2

You can try

Right (DSLink.field, 3)

if you are sure of every file having an extension 3 character long.

loveojha2

I need help in how to use this as a before-job subroutine and how to retreive the answer for use within the job Open the Routine, change the Type of the Routine from the Transform Function to Before/After Subroutine . It is one of the combo box available right next to the Routine Name. But To get t...

Search found 358 matches