DSXchange

Cache sharing requires other things to be configured. You can read about these in dsdskche.pdf. Meanwhile do not enable cache sharing - the separate processes will create separate caches and, design ... O.K. will change. Then what should I do to be able to read the same hash file from two different...

There's nothing required to make this work if both are just doing lookups. You've got a problem with the job itself that got back 0 rows. ... I am sure the two job should both return rows. Actually in the 0 row returned job, all the records are tranformed to the not found output link. When I run th...

Hi all, I am running two jobs in parallel from a sequence. Both of the jobs are extracting data and using the same hash file (file name: hsh_max_batch_number) as look up stream. However, it always turns out that one of the job get all rows back and the other one get 0 rows back. In both of the job p...

Actually I figured it out yesterday. And the code is similar to yours. Thank you for your kind response, Kim.

Kathy

In a transform function, I have the code as following: (the two pass into parameters are: HashFileName, Key1) *-------------------------------------------------------------------------------------------------------------------------------------------- RoutineName = 'ReadMaxCenYear' Common/HashLookup...

That they can't be found on the reference link must be detected in your Transformer stage, probably in a constraint expression on an output link. You have two choices. You can test the value of the link variable oletgtPostalCdIn.NOTFOUND You can test whether oletgtPostalCdIn.postalcd_wid is null (m...

Hi Ray,

Use your method, the job now can detect records that to be updated (find from the reference link but with non-key column value changed). But it still could not find the records to be inserted (key values can not be found from the reference link).

Kathy

O.K. My first query(this is in the mainstream oledb stage): link name: oleRawTableIn SELECT DISTINCT postalcode , convert(datetime, (left(birth_date, 4) + '-' + substring(birth_date, 5, 2) + '-' + right(birth_date, 2))) as 'birth_date' , case ret_date when '19000001' then convert(datetime, '2999-12-...

Then simply bring in all rows from one and do the lookup against the other. You can also bring all of one into a hash, then stream the other in and do a lookup against the hash. Do you mean a user-defined query can not directly look up another user-defined query? BTW, I have already used a hashed f...

The two tables are from different servers and there is no link between the two servers.

HI, I have a doubt in OLEDB connection. In the conncetion string when i hard code the parameters for catalog & source it works fine,but when i pass parameters it is not working. I have give below how i passed the parameters.Is there any thing wrong with my approach ? Connection String: Provider...

In my job, I have two oledb stages (for data from different server and databases). Both of them out put data using user-defined query. Can 1 stage looks up the other one?

I figured it out. My new query statement is as the following: select 'N' as 'date_fl', max(dim_dt1) as 'dim_dt_id' from dim_dt where dim_dt1 is not null union select 'Y', max(dim_dt2) from dim_dt where dim_dt2 is not null The only difference is I used quotes around my column names. Thank you for eve...

Doesn't matter, it's a quoted literal. As noted, are you sure this runs fine outside of DataStage?[/quote]

Yes. The query runs O.K. in query analyzer.

The problem is the first column is not from the table, it is created on the fly.