Uploaded image for project: 'Teiid Designer'
  1. Teiid Designer
  2. TEIIDDES-1315

Flat File Importer creates view model with column lengths not equal to those defined by the view's transformation query

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Major
    • 7.7.1, 7.8
    • 7.6, 7.7
    • Import/Export
    • None
    • Hide

      Select the File Source (flat) importer
      Point to the directory containing the file (I attached the one I used)
      Fixed width, don't use the column headings, data starts in the 2nd row
      Clear the column data, if asked.
      To define the column widths, select the data up to the next column (there are no blank spaces between each column. There's another picture for this.)
      When finished, check the transformation and the created view model's table

      Show
      Select the File Source (flat) importer Point to the directory containing the file (I attached the one I used) Fixed width, don't use the column headings, data starts in the 2nd row Clear the column data, if asked. To define the column widths, select the data up to the next column (there are no blank spaces between each column. There's another picture for this.) When finished, check the transformation and the created view model's table

    Description

      At the conclusion of using the flat file importer to create a view model, the column lengths of the model should be defined by the transformation SQL. In this case, all columns have a length of 10 despite the transformation specifying lengths of 5, 10, and 15. (See the attached screenshot.)

      Attachments

        Activity

          People

            parichar@redhat.com Paul Richardson
            pnittel_jira Paul Nittel (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: