3 Replies Latest reply on May 1, 2013 9:10 AM by rareddy

    Auto generate option for  views

    virtualdatabase
    virtualdatabase Apr 29, 2013 4:11 PM

      Sugggestion:

       

      If columns are defined for a view add a button to auto generate stubbed-query to make it valid...

       

      I.e. select null as column1,null as column2, convert(null,timestamp) as column 3......

       

      Also.. add a high level option at the model to do this for all 'invalid' objects due to missing transformations..

       

      Might want to add button to do this {or not} when generating view models (like from XSD or other simiilar methods)

        • 1. Re: Auto generate option for  views
          rareddy
          rareddy Apr 30, 2013 8:41 AM (in response to virtualdatabase)

          Typically the modeling for a view considered to start with picking the source tables/views involved with that view, in that case the default transformation is generated based on name matching. I do not see much value in providing the above request, not to mention gives a false status of view being "valid", where it is not. May be an option in the "Reconciler Window" to add that button would be good, when there is no good conversions are available. You can do this now, but you would have to manually enter null.

           

          Ramesh..

            • Actions
          • 2. Re: Auto generate option for  views
            virtualdatabase
            virtualdatabase Apr 30, 2013 10:24 AM (in response to rareddy)

            It happens often enough in the development cycle that I feel it a worth addition...  Especially in context of a generated object from XSD or possibly WSDL would have the same purpose.. ANY time a "top-down" approach to modeling is being done I can see the value.. Maybe I'm in the minority but I know it's often that I have, through the iterative process of development, have a partially finished object that I need to do something like this (or delete it) before I can test other components within a VDB.

              • Actions
            • 3. Re: Auto generate option for  views
              rareddy
              rareddy May 1, 2013 9:10 AM (in response to virtualdatabase)

              I am just advocating where this may fit in. You can log feature request in Teiid Designer, it is upto the Designer leads to give the priority to the issue.

                • Actions