Hitachi Vantara Pentaho Community Forums
Results 1 to 5 of 5

Thread: Updated table attributes aren't loading in Table output

  1. #1

    Default Updated table attributes aren't loading in Table output

    Hello...
    I am using table output for putting the json attributes into a table 'Newemployee'. My table structure in oracle is 'Newemployee(fname, lname)'. Now after adding a new column 'did' to 'Newemployee' through oracle cmd(i.e. Employee(did, fname, lname)), I am unable to see 'did' getting populated in the field mapping tab of Table output. Even if I create a new connection, the newly added field isn't populating.

    I am attaching the screenshots of table output mapper tab and the actual description of the table.
    Attached Images Attached Images   

  2. #2
    Join Date
    Jun 2012
    Posts
    5,534

    Default

    Use menu action Toolsatabase:Clear-Cache to let Spoon learn about your database schema changes.
    So long, and thanks for all the fish.

  3. #3

    Default

    Oh I got it... Thank you so much for the help...

  4. #4
    Join Date
    Aug 2015
    Posts
    313

    Default

    Quote Originally Posted by marabu View Post
    Use menu action Toolsatabase:Clear-Cache to let Spoon learn about your database schema changes.
    Sir , is there any problem if i un-check "Use Database Cache" option in kettle Option general settings ?

    Is it good to maintain "Use Database Cache" or bad for PDI performance ?

  5. #5
    Join Date
    Jun 2012
    Posts
    5,534

    Default

    No problem I'm aware of. It's a Spoon convenience feature to speed up your design phase. Just try for yourself, you won't break anything.
    So long, and thanks for all the fish.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.