DSXchange

1. yes

2. no*



* only thru carefully hacking the .dsx you might be able to nudge it in, but you can't have used any 7.5 features or stages not support under 7.1

This sounds like a permissions issue. The userid you are using, is it the right role for doing imports (use Administrator client to check)?

The data integration business is not kiddie play. There's no magic fairy dust you can sprinkle on people to make them move billions of bytes of data better. The ETL Genie does not grant wishes for moving data faster just by checking a box or tweaking an array size. Someone who attempts to load 2 bil...

Oracle OCI, not Oracle ODBC. ODBC is Bill Gates revenge on the Unix world. Oracle, UDB, Informix, and Sybase all have their own connectivity software for their databases. OCI, CLI, whatever the moniker. ODBC is a PC thing foisted on the Unix world. In theory, database vendors know their databases be...

Sneak a look at the *.adm files in each project.

Yeah, they've got to mindwipe everyone into a PX frame of mind. You'll hear the same argument from Oracle about writing queries and using work tables. Here's a document that's really illuminating. It shows how landing of some data in Oracle facilitates getting your end results faster. m I worked wit...

Ken, How may multiple single row subqueries can we include at a time. I mean taking your example, you have FOUR single sub queries. In that way , what is the maximum sub queries we can have? As much logic as your database SQL parser can handle. It is just SQL after all. If you have something like a...

I don't think you understand what's going on. There's an outer select that simply qualifies the customers you are interested in having in the output. This query is stand-alone, it will work. select yct.customer_key, ... ... from your_customer_table yct where customers_are_these_guys... Now, add a si...

In the short run, just use the servers clients to do the exports and imports. You can go to one server, start DS Manager, export there, reconnect from that server to the other server and do the import.

They don't matter. DS Server stores all data in hash files as strings (see the recent newsletter for a little discussion about hash files). DS Server is amazingly flexible with datatypes, since everthing is a string. Dates are strings, numbers are strings, etc. You don't have to cast a string to a n...

Are other projects okay on the new server and just yours is the problem? It sounds like it's either a corrupted project or not all components are there. If your project is the problem, just drop it and create it fresh rather than go thru the reindex shuffle. Import your .dsx and see if it's okay. Ma...

Well, actually, my posted query is rather poor in performance, but easy to understand. If you want to do it at optimal speed, you would create a work table for each subselect column and simultaneously execute the queries. As independent queries, they'd be working simultaneously populating their own ...

Thoughts: Both servers are running the same release of DS Server? The new server project has all of the plugins installed? The .dsx file is a common denominator, does it include all source or is it just executables? If you can see the designs, it should include the source I would think. The userid y...

Ever seen SQL like this? select (select count(1) from your_attendance table yat where yct.customer_key=yat.customer_key and some_criteria... ) "FIRST_METRIC", (select count(1) from your_attendance table yat where yct.customer_key=yat.customer_key and some_other_...

lot of approvel process by the people know "nothing" about what we are doing But for some reason your company seems to think these people need to bless your promotions into the QA environment. -+- sigh -+- So what you are asking is for a way to bypass the Protected project state and sneak some chan...