DSXchange

A "reducer" is a function which causes fewer rows to exit than entered, sum() or group by for example. What exactly are you doing in the Aggregator?

Work with your DBA to ensure your database is configured with enough "rollback space" for the operations you are doing. Work with your DBA to determine why the process is hung when it hangs. This is not stuff you can figure out or change on your own, you need to work together with those re...

You are misinterpreting what "insert array processing" means. As you've noted, for all practical purposes Open & Close are synonymous with Pre & Post SQL.

What exact 8.x release are you on?

(my reply from the just delete double-posted question)

Surely there are other tools more appropriate to this task than an ETL tool?

Why not one of the tools built into Windows / Office like VBA, for instance?

That's the thing James has been trying to tell you - there is no "Java API" for a script. You simply run Java itself just like any other command and pass it the name of the jar file to execute. That or you use one of the tools available to turn the jar file into an executable and run that....

We interrupt this post for a brief Public Service Announcement :idea: If you use any tags (like bold or italics) in your post, you cannot also check/enable "Disable BBCode in this post". :idea: Use the Preview button to see what your post will look like before you post it. That way you ca...

Ray Wurlod with a link to the IEEE Floating Point Standard (754-2008) in 3... 2... 1...

I am looking for a technical guidance not anything else as you are experts ,you can help us...but you are not doing so...so bad :? Baloney... you've stated more than once you are looking for code which is what people are having an issue with - and then you won't take the code that is freely offered...

Thought probably not conclusive, there's nothing here that seems like what you are looking for.

In order for people to help, you need to answer the questions being asked of you. For example, James asked two in the first part of his reply and Kryton had a couple as well. I'd also be curious how you are partitioning the data, what method you chose.

Sorry but this doesn't make much sense. Does that example go into four fields or one field? Did you really mean to only remove one of the quotes around the word NULL?

Please try again to explain your requirement.

There's failover and then there's transparent failover. Which are you looking for? Disclaimer: I have no clue if SQL Server supports the latter, I just know the difference exists as I've had to deal with it in other environments in the past.

That's been an issue for-ev-er for the Plug-in Metadata importer. Try the PX-specific importer orchdbutil instead.

kurics40 wrote:I dont know how to invoke the compare tool from command line.

Oddly enough, it's fully documented. Designer Client Guide, Chapter 9.