DSXchange

thanks again, james I created a new project from the Administrator Client...and I get the same problem....there are also other error messages(not appearing in this order necesarely): "Error calling subroutine DSR_EXECJOB (Action=5); check DataStage is set up correctly in project NEW (The connec...

thanks for the reply

As far as the project you created from the command line, you can't.

Would this situation change if I create a new project using the Administrator Client?

Hi, James

Yes, I am still able to connect to the DEV project and run jobs.
How should I create a new project so that it automatically re-syncs with XMETA?

thanks

Do you know where DataStage keeps the logs related to projects?
Maybe I can debug it easier this way.

thanks

Hi, I have created a new project(NEW) on the same machine where the development project is(DEV), using the command line: dsadmin -domain <domain> -user.... The project is successfully created and has the same output for "dsadmin -listproperties <project>" as the DEV project. The problem is...

Hi, I made a job that standardizes multiple attributes in the same STANDARDIZE stage (I have 10 attributes in this stage). The problem is that one of them (one that standardizes names) returns a flag suggesting that the field is NULL, even if it shouldn't(the field is not null, and does not become n...

Thanks a lot

Hi, I'm using a Dependent Unduplicate Match. I haven't found anywhere described the process of choosing the rows that go on the MATCH flow, vs the ones that go on the DUPLICATE flow. How does QS choose between them; how are the ones that go on the MATCH flow better than the ones from the DUPLICATE f...

It was because, instead of writing the survive rules in the stage (in the graphical mode), I modified the .dsx file. When I imported it, I compiled it and the result was that it didn't evaluate any of the rules. I solved the problem by clicking on the survive stage and pressing OK(I guess that in th...

I eventually solved the problem...it was not about the number of survive rules(I think you can have as many as you wish). Thanks for the reply

Hi, I am having a problem with the survive stage...I have a lot of attributes to survive, and I noticed that the survive stage doesn't work in this case. If I only try with 2 attributes(having 15 rules), they survive properly. But when trying with all the attributes, the rules seem not to apply any ...

Hi, I am having troubles in compiling a DS job. This is an imported job, and the problem is that I want to make changes to it, to a transformer more exactly. I even tried hard coding some values to make sure that this is the problem. And it proved to be, because at the output I get the same values t...

Are you sure it's a good idea to have all 3 columns both present for blocking and for matching?

I'm not completly sure about this, but can't this task be accomplished by using the SCD stage?

If you only have one single quote, this should work in a transformer:

If Index(DSLink2.col,"'",1) <> 0 then Field(DSLink2.col,"'",1) : ("":'"':"") : Field(DSLink2.col,"'",2) else DSLink2.col