Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: Probleme FK in diff tables

  1. #1
    Join Date
    Mar 2016
    Posts
    18

    Default Probleme FK in diff tables

    Hi every one
    I wanna to do a job for Pentaho Kettle and i have my transformation Name:  Opened By.jpg
Views: 29
Size:  28.6 KB
    this its work fine . but the probleme in step befor insert agent (fields name agent Opened my tickets ) i wanna to do test for this field with 2 another field Closed By , and Assigned to .

    if agent open this tickets i have his id and insert it in my ticketes FK , if agent closed tickets agent take his name and insert id (FK Closed By) in ticket .
    if agent Assigned this tickets i have his id and insert it in my ticketes FK , if agent Assigned tickets agent take his name and insert id (FK Closed By) in ticket .
    this is shema Name:  Agent FK.PNG
Views: 29
Size:  22.6 KB

    thanks for helping

  2. #2
    Join Date
    Mar 2016
    Posts
    18

    Exclamation Pb FK

    Hi all
    i wanna a help please
    this is my transformation in attach Test1.ktr
    and i wanna before inserting in table agent (insert agent ) do a test
    i have 3 field in my job (Assigned to , closed by , opened by ) in my agent i insert opend by
    i wanna to test here Name:  Shema BD Power AMC.jpg
Views: 34
Size:  29.0 KBin my test
    if opened by = closed by , insert in my agent and his id i will insert it in my ticket in FK_Closedby
    if opened by = Assigned to , insert in my agent and his id i will insert it in my ticket in FK_Assigned to
    Name:  Agent FK.PNG
Views: 33
Size:  22.6 KB
    thanks for helping
    Attached Images Attached Images  
    Last edited by zaki_java; 04-08-2016 at 11:12 AM. Reason: Changing Shema

  3. #3
    Join Date
    Mar 2016
    Posts
    18

    Default

    heeeey every one help please

  4. #4
    Join Date
    Apr 2008
    Posts
    1,771

    Default

    I would split that transformation into multiple transformatinos, especially if you update some tables and then do a lookup to those updated tables in different steps within the same transformation.

    Note that steps are initialised at the same time within a transformation and if you use many steps that access the same DB you could have issues.
    -- Mick --

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.