Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Defining a column as key

  1. #1

    Default Defining a column as key

    Hi,
    Is there any option to define a column as key in the transformation, when is not defined so in Database?? Thanks in Advance!!

  2. #2
    Join Date
    Sep 2009
    Posts
    810

    Default

    If you want to check if a column is a key, there should be some SQL specific to your DB that allows you to check for that.

    Something like "SELECT KEY COLUMNS FROM TABLE foo" maybe. Check your DB docs how to find the keys.
    Checking that list for a specific column and executing "CREATE INDEX ..." should be no problem I guess.

    Cheers
    Slawo

    PS: If you want to do it the hard way, there's also a JDBC driver method that can be used, If I recall correctly.

  3. #3

    Default

    Hi,

    I know the key columns. But my question is, how to redefine a column as key.

    For example, if a table T1 is having columns C1, C2 and C3. C1 is the key column. After doing a look up with table T2, i want to make the column C2 as key along with C1. How can i do that?

    Thanks in advance.

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.