DSXchange

You might like to read the Technical Bulletin dsdskche.pdf to gain an in-depth knowledge of different possibilities for hashed file cache, such as private link cache, public link cache and shared cache.

You haven't even looked at the routines I suggested, have you?


Leap years actually do not matter in an AddYears() function unless the current (base) date is February 29th or the Pope has adjusted the calendar in the interim.

Not really pretty, and definitely not optimal. Piping through tail -1 (or tail -2 | head -1 if necessary) would have been easier on system resources.

I personally have answered this question more than once here, and I know that others have also. Search the forum to find these answers.

There is another macro called DSJobStartTimestamp. No prizes for guessing what this gives you!

The job design itself won't take more than about 50KB when first designed. The log file will grow indefinitely unless you specify purging, and provided that you resize it to 64-bit addressing before it reaches 2GB. How much scratch space you need depends on how much memory you have and, where possib...

If you know what the character is, you can use the Trim() function. Otherwise you can create a routine that scans the string, returning a string from which only the printable characters are returned. Without NLS, these are characters in the range 32 through 127 and 129 through 255, except on Windows...

That's because there's no such intrinsic function. Which is not to say karrisuresh has not written one - if so, why not share it?

Do you have the DataStage Engine bin directory in your command search path (the PATH environment variable)? The error message suggests that you do not. You can test this theory by using the fully qualified pathname of the command, for example /usr/Ascential/DataStage/Engine/bin/dsjob -options projec...

What is the data type? The Data Browser always displays Decimal and Numeric data with leading zeroes, so it may be that the source data do not even have leading zeroes; what you are describing may simply be an artifact of using View Data. And nothing you do except changing the data type to string wi...

You have run out of space on the file system where the hashed file lives. RESIZE makes a copy of the hashed file, so you need another file system that has at least this much space - plus the overhead of the larger (64-bit) internal pointers. RESIZE has a USING option that you can use to specify a fi...

To me, data lineage is any form of analysis that allows an end-user's "where did this come from and (if required) what calculations were performed in the process?" question to be answered. Maybe this one, that I just thought of: Data lineage is to source-to-target mapping document as physical design...

Manage your expectations better. A minute to delete 2 lakh rows isn't too bad, remembering that it's a transactional operation so there will be some overhead in managing the transaction(s).

Or invest in more powerful hardware. I'm sure your vendor would be happy to take your inquiry.

vijaydev wrote:Pls. tell me any function is there to add one year to a given date

Yes there is.

I gave you a link whence you can download a whole suite of them.

If you want more help than that, such as designing your ETL, that counts as consulting, and will cost you.

On a Windows platform, and provided that the Oracle environment variables have been set for the user who executes the DataStage job, installing the Oracle client software on the DataStage server machine should be all you need to do.