DSXchange

I'm confused. The technique to read xml using the External Source "is" using the filename --- that's how it works...you issue an operating system command like unix list (ls) and send only the filenames downstream.....

...is that what you want?

Ernie

...and if you are reading this and using 9.1, the Sequential Stage introduced an ability to write to multiple files based on a break of some kind, similar to the trigger in the xmlOutput Stage, so you could send you content on each row and then use a Sequential Target (in 9.1 and above).

Ernie

I've also played games with using a Server Job and sending the split xml content downstream as individual rows to a folder stage. Been awhile, so I don't remember how flexible it is, but the folder stage has a few ways to create multiple files also.

Ernie

Suggest you start a new thread on configuring IMAM....and for your purposes, you should only need a single Metadata Interchange Server (go to the Administrator page of IMAM and then configure a new one that is set up for your local Info Server instance) to reach the "Connectors".

Ernie

Those steps are among the things that you need to do for DataStage Jobs to be connected to Database Tables that have been previously imported to Information Server .....and the tables that you choose will hopefully also be the tables that are imported automatically along with your cognos bridge....w...

the file is nothing more than a pointer that shows "which" columns map to the ones that Metadata Workbench requires....it doesn't change what is imported into an Extension Mapping. Those columns are already formally designed...by the names you see in the user interface along with any custo...

The mappings assume that you already have your sources and targets..........that means that you have imported those sources (tables?) and targets (other tables?) from relational catalogs, bridges, brokers etc. Extension Mappings are merely the "glue" between a source and a target that have...

The best way to get the metadata is to use metadata asset manager and import the metadata directly from the database catalog via "Connector".....but there are many other ways........other bridges and brokers used within metadata asset manager, the older import/export manager using bridges ...

The column headers aren't necessarily the same for FastTrack and for Extension Mappings, but in 8.7 there is a mapping xml file that you can use....it is described at the import page of the metadata workbench. If you are using something prior to 8.7, you will need to update the column headings in yo...

They have nothing to do with each other. If you have (say) 100 databases that you want to govern, then you could import them all and they will appear in Metadata Workbench......add stewards and notes, assign them to Terms, etc. etc. If 3 of them are interesting to your DataStage users, great! ...the...

Well...the problem is an Operating System one......another process (in this case DataStage) has the file open.......you need a way to read it.

Ernie

Most likely it is working just fine.....send it to a database instead, with a commit value of 1.....the file doesn't get closed, so you can't see it. but if you write to a database with commit=1, you can view it immediately via other tooling.

Ernie

I haven't seen this in awhile. Noticed it most often when there are very few columns in the sub-columns of the repeating node. Try this: Add a dummy column that is 100% unique (use something like @INROWNUM upstream)...put this dummy column just above ProdCode in the link and give it xpath (the Descr...

As noted above, check out the details in the blog url. One of the key things you will see is to find yourself a testing tool, such as SOAPui or Actional Soap Tester, and install and use it. Get to know the service very well, and its behavior, and its execution requirements (headers, etc.) using an e...

Like a lot of things, "it depends". If the service is simple single-row-in and single-row-out, and has just single fine grained parameters, just import the wsdl, select your Operation at the main Stage button, and then "Load" the messages on the input and output link. You will se...