DSXchange

Yea check your NLS installation. what are you using the DSR_NLS routine for ?

Hashed files are seperate files the are created via the DS application. It has no effect if the job is deleted or changed. The next run of the job can variate the content of the file.
Its just like saying if I delete a job, will the target table be deleted

Yup it works gracefully. I just ran a test on it.
Your all set Thibal.

hey, Thibal, waitup i did a search and found a reply by vmcburney, i knew the DSgurus would know, this is his reply "It's easy, macros can be treated just like job parameters, you can use DSJobInvocationID in your file paths and file names surrounded by # characters. I've done this in the past ...

if you want to use it in a job name then i would say yes, no other choice but to use a job parameter.
Maybe the DS gurus know of some other way, as far as my knowledge, you have to use a job parameter (variable between two #'s)

go to macros, and then choose DSJobName.

One small tip to avoid these issues, is PLEASE gracefully logoff from DS or any DB services.
The processes are left hanging under each user hence increasing the load of processes. :D

A server container can be used in PX a.ka EE, but it is highly not recommended by the product vendor since it invokes the DSserver engine for the process.
It might possibly even give you performance issues.

Did you also try removing the Reject status in the stage.

In order to solve this problem you need to have a look-up of City to Country (Code or Name). From the transformer filter those rows by having the logic IF Link ISNULL and store it in a Dataset. Then use that dataset to lookup into the City to Country data set that is provided to you. That should sol...

DSX search engine is my best friend, make it yours too

the solution to your query is here

Good Luck.

Welcome aboard, Let me give you a friendly advice buddy, a lot of these topics have been already covered here. If you want the solution to your problem fast, make the Search option your best friend. I did a search and found this, check it out http://www.dsxchange.com/viewtopic.php?t=93260&highli...

o i forgot to add,
if the hash file is outside the DSRepository, then you need to create a local VOC entry.
You can use the "SETFILE /path/to/your/file hashfilename" and then a "ANALYZE.FILE hashfilename" to do this. [/code]

start the DS admin, go to you project and in the command execute the following command
that should give you the size of the hash file along with other hashfile info.
i hope it helps

Samba, if you have a column in your source table that maintains the timestamp of when that record was last updated or inserted, then the most easiest thing for you to do is, just select the changed records from your source table. in the DRS stage, select user defined SQL and in sql select only chang...