Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. trobinson

    MQSeries Real-time Processing

    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)...
  2. trobinson

    Function Call from DTS

    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...
  3. trobinson

    Extracting XML Document

    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.
  4. trobinson

    Best Tool To Build A Cube??

    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...
  5. trobinson

    Code base or engine base ETL tools

    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...

Part and Inventory Search

Back
Top