DSXchange

Thanks.
Good point re: concurrency.
I'll play with the surrogate key generator some more.

chulett wrote:Using the sequence directly would mean all that is already handled by the database.

Using directly means either using the sequence in a sparse lookup or manually coding the insert sql? I take it that using the surrogate key generator would NOT be recommended in this case.

I need to do something similar, but I have one concern about using the surrogate key generator: What do I need to do to update the sequence in the database?

There are other non-DS processes (web services) that use the sequence in the Oracle database.

1. No chance yet to explore pure xslt, but that sounds interesting. 2. Datastage is smart enough that when I'm populating an element AND its attributes, it doesn't create 2 sets of tags. I'm sure everyone else knew that, but I didn't :oops: 3. So I can put the 2 rows in the input columns for the xml...

I guess the next part would be to try coding a conditional xpath expression. Then I wouldn't need to add the extra output row.

Found an alternative to hand coding the xml (option 2 above). Not sure its any BETTER, just an alternative. For upstream transformer, lets suppose target column name is Colour. create a 2nd column ColourNil immediately before or after this column. make both target columns NULLABLE. In the derivation...

Thanks Ernie. That's actually my option 2 above. And since there are ampersands in some of the data, I have to make the element XML when passing it to the XML output stage. The problem is that I have to do this for several jobs and many elements per job. I was hoping that, since I had imported the o...

http://www.dsxchange.com/viewtopic.php?t=130297 http://www.dsxchange.com/viewtopic.php?t=117035 http://www.dsxchange.com/viewtopic.php?t=116064 http://www.dsxchange.com/viewtopic.php?t=10187 http://www.dsxchange.com/viewtopic.php?t=109788 I have read through the above and I am still not sure. If I w...

Thanks. That seemed to work.

The problem returns when I try to send the output to another stage or to a Dataset Stage. Sending the output to a Sequential File Stage is what solved the problem. What APPEARED to be the solution from the previous post was coincidental as that output was written to a sequential file. As soon as I c...

No parameter setting seemed to work. I was building detail xml chunks in one xml output stage and aggregating in the next (copy stage in between). I've done this before to control the way the xml is formed and haven't encountered this problem before. I'm still verifying that the generated xml confor...

Ran into the low watermark message as per viewtopic.php?t=128506.

Is there any way for me to see what values DS is actually using at run time?

Thanks Ray. In the xml output stage, Output tab, advanced, cahnged buffering from automatic. Increase max buffer by adding 0 on the end (10 x) to from 3145728 to 31457280. Did the same for disk write increment. Changed from 1048576 to 10485760. Dies in exactly the same place. Same message. Will try ...

I've reviewed the following posts : http://dsxchange.com/viewtopic.php?p=23680046 http://www.dsxchange.com/viewtopic.php?t=109868 http://www.dsxchange.com/viewtopic.php?t=109896 http://www.dsxchange.com/viewtopic.php?t=126730 The job is creating XML using parallel xml output stages. The first stage ...

Thanks rcanaran, ContractRoleIdPK string repeatable in line with value. I need to delete all <ContractRoleIdPK> values </ContractRoleIdPK> values. Please give me command in unx See option 3 above. Use an external filter stage. with filter command and arguments set as above. If you want to process s...