Load Ingest Data
Results 1 to 2 of 2

Thread: AIS Metadata naming for SQLMP

  1. #1
    Costi Zaboura is offline World Wide Support Manager
    Join Date
    Aug 2006
    Posts
    300
    Rep Power
    14

    AIS Metadata naming for SQLMP

    AIS Metadata naming for SQL/MP

    If you use a local copy of the metadata or extended metadata, the data source name must begin with a letter. In addition, if you do not supply the Repository Information on the Advanced tab of the Data source editor, the default names that AIS generates for the metadata files will be unique. AIS creates a NOS file and a BBNOS file. The file names are created by using the characters in the data source name and then by ensuring that the first letter is legal on the HP NonStop platform. To make sure that the generated files are unique, you must make the sixth through eighth characters of the data source name (or last three characters if the data source name is fewer than 8 characters) alphabetic and unique.

    If you supply the Repository Information on the Advanced tab of the Data source editor, make sure that you use the rule above when for the filenames created by the Repository directory (HP NonStop volume/subvolume) and name and not the data source name.

    Note: On the HP NonStop platform, the Repository Information objectStoreDir and objectStoreName attributes do not affect Alternate Key Files for the following data sources:

    . Enscribe
    . SQL/MP if a local copy or extended metadata is used.
    These are always created in the NAVROOT subvolume with uniquely generated filenames.
    Last edited by Costi Zaboura; 01-24-2007 at 07:25 AM.
    To Find Out more About Attunity Technology:
    Attunity
    or:
    Contact Us

  2. #2
    JeffS is offline US Technical Team
    Join Date
    Sep 2006
    Location
    Minneapolis, MN
    Posts
    20
    Rep Power
    0
    If you use a local copy of the metadata or extended metadata, the data source name must begin with a letter.

    In addition, if you do not supply the Repository Information on the Advanced tab of the Data source editor, the default names that AIS generates for the metadata files will be unique. AIS creates a NOS file and a BBNOS file in the NAVROOT subvolume. The file names are created by using the characters in the data source name and then by ensuring that the first letter is legal on the HP NonStop platform. To make sure that the generated files are unique, you must make the sixth through eighth alphanumeric characters of the data source name (or last three alphanumeric characters if the data source name is fewer than 8 alphanumeric characters) alphabetic and unique. If the data source name contains 5 or more alphanumeric characters the last 5 cannot be all Bís.

    If you enter the Repository Information on the Advanced tab of the Data source editor, make sure that you take into account the above for the filenames created by the Repository directory (HP NonStop volume/subvolume) and name and not the data source name.

    Note: the Repository Information objectStoreDir and objectStoreName attributes do not affect Alternate Key Files for Enscribe data sources. These are always created in the NAVROOT subvolume with uniquely generated filenames.

    The actual algorithm that AIS uses to generate the metadata file names is as follows:

    1. Take the data source name (or objectStoreName if applicable) and append the relevant string, "NOS" or "BBNOS".

    2. Take the last 8 alphanumeric characters from the string (or all the alphanumeric characters if there are fewer than 8).

    3. If the first character is not alphabetic replace it with the first character of the data source name (or objectStoreName).
    To Find Out more About Attunity Technology:
    Attunity
    or:
    Contact Us

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •