Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: transformation process description possible?

  1. #1
    Join Date
    Mar 2007
    Posts
    1

    Question transformation process description possible?

    eg.

    src table
    male, female

    dest table
    people

    select (id) from male + select (id) from female, and put the result into people.number

    and i want a description like this:
    1.table_people.number_all from table_male.id, table_female.id

    2.count(table_male.id) + count(table_female.id) = table_people.number_all
    or
    the sum of table_male.id + the sum of table_female.id = table_people.number_all


    that is: firstly give some descriptions to the tables and their columns, then form a description of the destination column as to where the data came from, and how is the data calculated.

    is it possible to interfere the process of kettle so as to get the result?

    i mean, by adding some source codes to kettle or whatsoever!?

  2. #2
    Join Date
    Mar 2007
    Posts
    11

    Wink Can You Give the ER D

    Dear,


    If you send ER-diagrams target schema and source schema, may be, just may be someone can help.

    regs,

    dedi m

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.