Hitachi Vantara Pentaho Community Forums

Search Forums:

Type: Posts; User: Murali Doss; Keyword(s):

Search Forums: Search took 0.02 seconds.

  1. Replies
    3
    Views
    3,053

    db lookup is very slow sql server

    I have db lookup for master table to fetch the id field in sql server and i have primary key for taht id field and also index for lookup key.It's very slow in sql server and same in fast in postgrsql...
  2. Replies
    1
    Views
    891

    Hex character input file step

    Hex character input file step is available in kettle ?I have input file with hex character..is it possible to read them
  3. how to read the Hex character (packed cobol data source)

    how to read the Hex character (packed cobol data source) in kettle input step.Let me know anyone used packed input data source in script if so give me some example to encode and decode hex or packed...
  4. Replies
    4
    Views
    2,863

    Thanks for your reply.Sorry for posting the...

    Thanks for your reply.Sorry for posting the queries in documentation forum.

    what db engine are you using - PostgreSQL 8.2.6 on x86_64-redhat-linux-gnu, compiled by GCC gcc (GCC) 4.1.2 20070925...
  5. Replies
    4
    Views
    2,863

    Thanks for your reply.Sorry for posting the...

    Thanks for your reply.Sorry for posting the queries in documentation forum.

    what db engine are you using -

    What kind of step for updating -

    Do you have indexes
    Kettle version
  6. Replies
    4
    Views
    2,863

    Bulk Update

    I have 3 million of records and it's takes 1 days to update only 100000 records.I like to know whether we can any concept of bulk update.

    There is no issue with database because insert for 3...
  7. Replies
    2
    Views
    1,097

    computed db value

    I need to store the output of these to variable in ktr (select count(*)+1 from tablename) and pass to next step.This activities i need to do for each row of input file
  8. Thanks a lot some how i did this before your...

    Thanks a lot some how i did this before your reply.Anyway thanks for your effrot.Can we have the kettle.properies file in different location instead of C:\Documents and Settings\userid\.kettle.
  9. Can we define the db connection in kettle properties file

    Can we define the db connection in kettle properties file and use it in kettle script...if possible please explain me how to use that in ktr script
  10. Replies
    1
    Views
    1,298

    change the path of kettle.properties

    Is it possible to change the directory path for kettle.properties instead of C:\Documents and Settings\user id\.kettle\ if so then how to configure the path in kettle script or Spoon.
  11. How to include Input CSV File in repository

    In the kettle repository,can we store any files other than .ktr and .job.
    I need to store the input source file (csv file) for the .ktr in the same repository
  12. setting input file name at kettle script run tim

    I am pretty new in kettle script and like to know whether we can set the input file name at run time or can we set virtual directory path to file name ( For ex: instead of...
Results 1 to 12 of 12
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

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