Forum Stats

  • 3,827,917 Users
  • 2,260,838 Discussions
  • 7,897,405 Comments

Discussions

filenames with postfix as a sequence

493163
493163 Member Posts: 2
edited Oct 13, 2008 9:44AM in Data Integrator
Hi,

I'm evaluating ODI for a customer (who plan to replace Informatica Powercenter with this produkt). I've set up and tested all functions from the old datawarehouse solution except how to load files with a sequence in the filename. The solution implemented (in Informaitca) is that the sourcesystem sends the files to the datawarehouse via a enterprisebus(publish/subscribe pattern). In this case each object/table transferred will start with the same name, but will den have a data and a sequence number as a postfix. Example, SOURCESYSTEM_TABLE1_20080901_001.xml, SOURCESYSTEM_TABLE1_20080901_002.xml etc.

In informatica we've built what they call a filelist to solve this. How can this be implemented in ODI?

kind regards
Jörgen
Tagged:

Answers

This discussion has been closed.