Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: how to move view data in etl

  1. #1
    Join Date
    Aug 2016
    Posts
    18

    Red face how to move view data in etl

    1)I am moving data in oracle sql to postgresql .but hear problem is in oracle sql have view tables
    so how can i transfer the view table from oracle to posgresql

    2)I want to move data from one database to another data base in single transformation. not table after table........

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

    Default

    Actually, you only transfer base table rows.
    If you need a view in the target system, just define it there, once.
    So long, and thanks for all the fish.

  3. #3
    Join Date
    Aug 2016
    Posts
    18

    Default

    Quote Originally Posted by marabu View Post
    Actually, you only transfer base table rows.
    If you need a view in the target system, just define it there, once.


    may i know how can i define it. please....

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

    Default

    You don't want to make a one-time operation (CREATE VIEW) a part of your ETL job, do you?
    I would lookup the view definition in Oracle and make the necessary modifications (if any) so it can be used with Postgres.
    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.