Dynamic flat file

dataservices job design
1

Hi,

How to handle dynamic flat file source in BODS?

Thanks

DbUoRdAsI :india: (BOB member since 2012-05-08)

2

Use wild cards (ex- *.txt) in the file format editor

Arun

Arun.K :us: (BOB member since 2011-10-18)

3

What do you mean by dynamic flat file?

ganeshxp :us: (BOB member since 2008-07-17)

4

Pick your topic: http://wiki.sdn.sap.com/wiki/display/EIM/Flat+Files

Werner Daehn :de: (BOB member since 2004-12-17)

5

Also, the ‘Adaptable Schema’ option may be useful to you.

Nemesis :australia: (BOB member since 2004-06-09)

6

Hi Experts,

I have a metadata table that gives me the source file structure based on incoming file name. I need a way to dynamically have a single dataflow/job to do the following,

  1. Look for the source file to arrive and read the name
  2. Based on filename, retrieve the file definition from metadata table
  3. Create a dynamic flat file format as source.
  4. Load this data into a target flat file, which is pre-defined. Some minor transform may be involved.

Kindly let me know how the above requirement can be met?

arunnura17 (BOB member since 2007-03-30)