DSXchange

Search is my suggestion.

What is theDifference Between Data Stage 7.5 & DataStage 8.0 The question is not amenable to a reponse, as there is no single difference. There are thousands, which is why no-one here is going to even attempt to list them. The information is available from the vendor. They even have a class (DX...

sureshchandra wrote:Hi,
To avoid complex joins what logic should i use ?

Whatever other join(s) will produce the same result.

Would it be sufficient to re-define the data so that a match was done on the leading part of the string? If not (which is what I suspect) you will probably need to add a new field containing just the two words, and match on that.

Yes, and this is the right forum to ask. Using the SOA components you can publish a DataStage job as a web service that the other tools can invoke. Only a small amount of extra work (adding RTI Input and RTI Output stages) is required to make your job "RTI aware"). RTI = "real time interface" is the...

Totally irrelevant to DataStage. The complex joins, as you call them, are entirely within the purview of the database server in question. In general, if a join is possible in the database, you should be doing it there, where it can be assisted by indexes (which is not possible within DataStage). You...

DB2 Connect client software should allow you to connect to any DB2 data source anywhere through the DB2 Enterprise stage.

That's the first you've mentioned that you're on a grid - that would have been invaluable knowledge to have in the initial post. I presume that "ckts" is supposed to be an abbreviation for "circuits", though I fail to see where the "k" comes from. There is clearly an upper limit on the number of vir...

OK, stop right there. This could turn into an infinite regression. Get "them" to provide you with a proper file, one where the delimiter character is not one that occurs in the data, and without quotes around strings. Tab-delimited suggests itself immediately, and is one of the options for exporting...

Not enough information. What complex joins are involved? What kind of source stage? What alternatives have you contemplated or investigated? Are there indexes in the database that might assist your joins?

Please post the exact and complete error message. Also please post the value of the control file property you have used in your File Set stage: that is, the pathname of the file whose name ends in ".fs".

I find myself wondering whether "resource bundle" refers to resources mentioned in the configuration file. Does the configuration file refer to resources that are not available on the node(s) in question? Too many files is self-explanatory, but why? It may be that the solution is to run with MORE no...

Simply because using transformer is a costly process eating up a lot of resources and should only be selected for mutlipurpose utility i.e. if you need to do some transformations, merge columns, add some extra columns in the output, reject based on validation failure; all this at the same time then...

There's no matching key, therefore there's no matching key. Whether you're using DataStage or not, this is your fundamental problem. One approach is to form the Cartesian product, but this is almost certainly not the correct answer. You need to harrass your data providers to give you some means of l...

The first question you need to ask is whether the double quote character within the data is validly there - if it is, then removing it is not the correct approach. Some examples of the source data would help. In the meantime I would suggest specifying no quote character (000) and stripping the leadi...