DSXchange

Use hash files before ans after the link collector. Use one hash file/per each input & output link of link collector.

I dont have MultiLoad Stage avialable with me. Is there any work around with enterprise stage itslef?

Hi,
I want to update a Teradata table. Is update facility avialable in Enterprose stage? I can see only Append, Create, Replace and Truncate Options in exterprise stage. or should I use Multiload stage/ODBC stage?

Regards,
Rejith R

Hi,
I want to write each row in my inpu file to a seperate file. File name is one of the columns of the file. This can be achived using folder stage in server job. What is the alternative in parallel job?

Rejith

ray.wurlod wrote: A Hashed File stage accesses a hashed file, which must have a primary key. Spend some time researching/learning.

A Hashed File st ...

This question is moved to server forum.

Hi,
I am using a lookup(using transfromer) in server job on a hash file. For each input record, I want to extract multiple records from the hash file. The moment I make any column as the key, the duplicates are removed from the hash file.

Please help

Is the UV stage available in server jobs? If yes, in which paltte? Yes, in the Database group. If you don't find it there, you can add it (Customize) I think UV can be used to connect to database only. My reference data is a flat file. So I am trying to use a hash file after the flat file. Can you ...

narasimha wrote:Duplicates are always removed in the keys from a hashed file.(Destructive overwrite)
A hashed file lookup returns a single row.
You will have to use UV or ODBC stage to achieve your requirement.

Is the UV stage available in server jobs? If yes, in which paltte?

Hi,
I am using a lookup(using transfromer) in server job on a hash file. For each input record, I want to extract multiple records from the hash file. The moment I make any column as the key, the duplicates are removed from the hash file.

Please help

DSguru2B wrote:Its a range lookup. Search on the keywords "range lookup". Do an exact search. ...

Is range lookup available in PX 7.5.1?
If not what to do?

chulett wrote:By "</>" do you mean "not equal"?

No .
It is less than ...
I want to use less than/Greater than/ less than or equal to in lookup stage.

Hi

Hi, I want to extract some records from the reference data based on(</>) criteria. ie. get a column from reference link which is <= the input column. If it is an "=" criteria, we can directly map the input and reference columns. How to put the </> in lookup stage. Or is there any other sta...

How to get the number of records deleted from a table. I am using an oracle_OCI stage and a dummy file. Is there any way to capture the number of records deleted?(In select query we can get the link counts) Any help regarding this will be appreciated.

Hi Craig,
The issue is solved :D . The deadlock was due to some other issue. Thank you very much!!!!!!!!!!!!!! :D