DSXchange

Is this the first ISD Job you have ever written? If so...stop and first deploy one that is super simple, just to fully understand the behavior. Have ONE column..pass it thru a Transformer. Make it integer and add 999 to it. Have ISDinput and ISDoutput surrounding it. Enable it for services. Compile ...

Well. Cool. Very interesting. XML tags into HTML tags. How big is the document? Do you have to re-arrange it too? Do you have to Transform any values before you set them up for display purposes? If it's fairly one:one ("change this main elemenet to the "body" and always make this elem...

....yeah...either that or perhaps try to go and get it again... (Repository...Metadata Sharing....) ..that will bring "Shared Tables" into DataStage. ...it also "might" have been brought in earlier and is no longer in sync. The icon changes somewhat...there is a reconciliation fe...

This isn't a place to do "selling", so I don't want to sound like a marketing slide.... but I'd still strongly encourage you to take a look at what release 8 has to offer in terms of business and data lineage and governance over your metadata, primarily with Business Glossary and Metadata ...

Reading it again, it might also be that there is some odd characters or other data causing issues. Make absolutely sure that you can open the resulting document (from step 1) perfectly inside of IE or firefox without error, and/or consider checking it's well-formed-ness on the web at the w3.org site...

I notice you didn't mention business users. That's fine, every site has unique needs, but it's worth noting that a lot of companies are starting to look at lineage and tracking of metadata from the business user's point of view......so that answering the "where did this value on the report come...

First...make sure you can just retrieve the xml column and put it in a sequential file. Once you are certain that works effectively, correctly retreiving the entire document, move forward. Sounds like you are doing validation (check box). Don't. Not for initial testing anyway. Get things working fir...

Describe also what you are trying to do with your xml transformation..........are you reading xml and putting it into something else (flat file, csv, rdbms)? ...reading xml and putting it into "another" xml? ....reading flat files or rdbms and putting all of those into a target xml? That w...

Hi Franklin... It would be interesting to know your site's goals. Is it for inter-dependencies between the offerings? Parsing of actual source code? Or just identification of it? Tools like this might be perfect for deep cross-searching of actual "source code" entries like "PROFIT_PCT...

Not sure what your goal is? You imported a physical model into Workbench from ERwin.... I will assume you can then see the host/database/schema/tables.... What's next? Are you creating a actual database somewhere in an rdbms instance? If so --- do it....using ERwin. Then import the "actual"...

You may want to consider looking at the new xml Stage in 8.5. It is no longer based on xslt for its processing....providing two possibilities... a) It left in a "filter" features that allows you to invoke xslt as it ingests the xml. I haven't had a chance to try it, but it is a way to pote...

There is no real formal "max"..... "till it blows up" is probably the only true statement you can make. There are too many factors that it is dependent upon, from the size of the payload, it's data, element tags, attributes, etc. to the amount of heap available for the WS Transfo...

You've changed subjects. Up above you noted that you have truly "not" well formed XML --- now you are mentioning an error that occurs on some DS Servers and some not? This seemed to be a design discussion, not a debugging one. Now I'm confused. I thought we were talking about xml where you...

Not sure if there is any other ODBC driver......I haven't worked with MS Access in a very long time. Perhaps there are ways to make it look like MS SQL Server. What you could do is build your own comma delimited structures and import them via istool --- it will require some work up front to extract ...

Use the Import/Export Manager -- it has an option in the pull down menu called the "ODBC 3.0 MetaBroker". That will also let you bring in your tables and columns.

Ernie