We are contemplating developing an EAI Realtime MQSeries DataStage job that will process XML Messages. We'd like to talk with anybody who is in production with such a DataStage configuration. The DataStage job will utilize the MQSeries Plug-in stage with a wait time of -1 (indefinite wait)...
Can you be more specific as to where in the DTS package you want the function to be called? If it is in a transformation that utilizies lookups then I would say make the function call from within lookup SQL and return whatever the function returns. In general you can call a function from...
Try a folder input stage and an input link from the folder stage to the XML Reader. Define the path and file in the folder stage. I don't know of any other way to do it.
If your Peoplesoft data is in any database that can be read with ODBC, you can use Impromptu. I would even go so far as to recommend using Impromptu as the data pump into Transformer. It makes a lot of things easier. If you can't and still want to use Excel you can easily use multiple...
Make sure that they demo the proper functionality to address your specific needs naturally. My personal crusade is metadata. Is the tool's metadata architecture open and not proprietary? Does it talk to other products? Is it extensible? Administration of the ETL processes like versioning or...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.