DSXchange

On average I have more or less the same row/s but time to time the loading time can be impacted by the server capacity and ressource availability. Most of the time I copy first source data from db into flatfiles, this speed up the the data mapping with hashfiles. (and I do read only what I need, no ...

On average I have more or less the same row/s but time to time the loading time can be impacted by the server capacity and ressource availability. Most of the time I copy first source data from db into flatfiles, this speed up the the data mapping with hashfiles. (and I do read only what I need, no ...

Why you do not format both file with same metadata just before the funnel stage, with a transformer for example ?

Hi Ray, Hi ArnW,

I finally solve my problem by writing a routine following your information.

I am using OPENPATH, READ, SELECT, and I am able to read the column needed. (In fact I have two keys, and concatening them works perfectly.)

Thanks for your precious tips !!

I would like to retrieve a column in a hashfile by specifying a key in the where clause, such as : SELECT * FROM H_MYFILE WHERE KEY_1 = Arg1 The hashfile is containing global parameters and is created in the Directory Path . If try try to execute LIST.DICT HF_MYFILE, I am getting an error "Tabl...

Thanks to eveybody for your help and assistance but I will take another delimiter as I was not able to solve this in time.

I am still curious to find a solution, later when I will have more time.

Cheers,
Tony

Hi Ray,

I works also with only 168... but the result is always the same.

How can I reject these "?" characters ? Can I perform a test on "?" in a Transformer.

Ok at best, the character should not be written...

Hi thanks Ray ! Part of my problem is solved. I have specified the correct number of delimited columns on the Columns grid. I have imported the table definition and specified 168 as the delimiter, this is also working fine. But I still have the "?" in the beginning of each outputted field....

The Fixed Columns option is unchecked. But if I also uncheck the option Suppress row truncation warnings I am getting the error : nls_read_delimited() - row 1, too many columns in record Otherwise, I was just looking for a delimiter character valid on the Host (udb), on Unix and Windows. I am slowly...

Hi

I had a similar problem when I moved from from dev to prd environment. I had to recopy the hasfile located in the project diretory to solve this (Hashfile : SDKSequences)

Have a look on the other post of the forum. They are already several information abouth you question.

Hi everybody,

thanks for your help and for your time

What are the different possibilities (if they are more than one) to perform an outer or an inner join between tables ?

(I know it's very easy question, but I've been trying so many things and I didn't get yet what i want...)

Hello eveybody,

I made some positive tests with the ClickPack and it is exactly what i needed...
thank you for help

I need to read an email within a datastage job. How can I do that ?
Any suggestions or experiences ? or is it really posssible...

many thanks

caltog