DSXchange

D'oh, I was in fault. Thanks Ray, UV stage works fine! Actually I create the VOC pointer in the before-stage subroutine of the transformer where I perform the lookup. Let's suppose I need to create there a second pointer, is it possible to define both the two pointers into the same value field of th...

Thanks for your answer Craig, I fear it.
I've already thought to the UV stage way ( :D ), but this hashed file has not been created UV compatible, and I can't modify it.
I'll generate a new one.

Bye,

Ale

Hi all, I've an hashed file generated by another process. In my job I need to use this hashed file but not all its keys are useful to me. i.e. My stream has 2 fields: - code1 - descriptionField My reference (the hashed file) has: - code1 (key) - code2 (key) - other column (not a key) Is it possible ...

Hi, I've looked at the Basic.pdf but it's not the same thing of "Programming with datastage BASIC" class.. Starting from the beginning I'm trying to preload my hashed file in a searchable structure.. have someone got some pieces of information regarding it? I searched the forum but I haven...

ray.wurlod wrote:Time to mark this thread as resolved.

Yes, you're right.

bye

I'll take a look at the basic guide this weekend, I hope I'll find something of useful to me

Sure, here are the topics I was talking about: http://www.dsxchange.com/viewtopic.php?t=82431 (the last post) http://www.dsxchange.com/viewtopic.php?t=84692 (4th post) and this one, but it contains premium contents.. http://www.dsxchange.com/viewtopic.php?t=84998 The first post in particular is the ...

Hi to everyone. Well, I know that is not possible to make a range lookup with an hashed file directly. My situation is this. I've a stream from an oledb stage and an hashed file as reference linked to the same transformer. Hashed file is previously filled in with data obtained from another table. it...

Good, it's exactly what I need :D

Thanks a lot for your precious help.

Bye

Thanks a lot for your answers, I think I'll use Iconv
Only a question: are there some differences by improving the date-difference in a routine and use a transform function instead of directly in the transformer stage ? (firstly loss of performance)?

Thanks

Hi to everyone, I've a problem with a difference between two dates. I have improved a lookup between an oledb stage (sserver 2005) and an hashed file previously filled in another job with data get from a sql server table. In the transformer where I perform the lookup, I need to obtain a difference (...