Hitachi Vantara Pentaho Community Forums

Search Forums:

Type: Posts; User: juanvg1972; Keyword(s):

Page 1 of 2 1 2

Search Forums: Search took 0.02 seconds.

  1. Ok, is a good solution, I will try, you mean to...

    Ok, is a good solution, I will try, you mean to redirect error to other step, isn't it??

    Thanks
  2. Using data services to find a particular row

    Hi,

    I have an error in Pentaho DI when inserting rows in a target DB table.
    It's an error of data types in a particular row (for example: rowid 1230).
    Now I want to locate that row (rowid=1230)...
  3. Replies
    1
    Views
    549

    PDI and Cloudera

    Hi,

    Does anybody has experience working with PDI and Cloudera
    any idea respecto the above problem?

    Thanks
  4. Replies
    1
    Views
    549

    Error conecting PDI with Cloudera

    Hi,

    I am trying to connect PDI 7.1 comminuty with Cloudera 5.4
    I have followed ths steps in https://help.pentaho.com/Documentation/7.0/0H0/Set_Up_Pentaho_to_Connect_to_a_Cloudera_Cluster

    I...
  5. Replies
    0
    Views
    1,117

    Error connecting Pentaho DI with Cloudera

    Hi,

    I am trying to connect PDI 7.1 comminuty with Cloudera 5.4
    I have followed ths steps in https://help.pentaho.com/Documentation/7.0/0H0/Set_Up_Pentaho_to_Connect_to_a_Cloudera_Cluster

    I...
  6. Problems in Pentaho FI trying to read HDFS file

    Hi,

    I am tryng to read a file from HDFS in Hadoop from Pentaho DI and I am getting problems:

    - Pentaho DI (open source) in a local machine Win 7 version 6.1
    - HDFS in a Virtual Machine...
  7. Problems connecting to HDFS in Cloudera from Pentaho DI

    Hi,

    I am tryng to read a file from HDFS in Hadoop from Pentaho DI and I am getting problems:

    - Pentaho DI (open source) in a local machine Win 7 version 6.1
    - HDFS in a Virtual Machine...
  8. Differente executions envionment in Pentaho

    Hi,

    I would like to know which is the best way to move jobs and transfirmations from ine environment to another.

    I have some kjb and ktr files in Pentaho in test environment and I have some...
  9. Question about database update in Pentaho

    Hi,

    I have a question about database Updating step in Pentaho.

    I am using this step and I would like to know if it is possible to force the use of a database index in the update operation from...
  10. Ok, I undestand, thanks!!

    Ok, I undestand, thanks!!
  11. Thanks for your help. I suppose that this is...

    Thanks for your help.
    I suppose that this is not possible at transformation level
  12. Re-execute a job from a intermediate step

    I would like to know if it is possibl to execute a job from a intermediary step.
    I have a job with steps, once is executed completely, can I reexecute from a intermediary step.

    Any help about...
  13. Replies
    2
    Views
    710

    Thanks!!

    Thanks!!
  14. Replies
    2
    Views
    710

    Jobs orchesttation

    Hi,

    I need to fo a orchestation job in Pentaho DI. A job that calls other jobs.
    I want to use conditions that check if a job has finished succesfully to call to next job.

    start -> job1 -> if...
  15. Transformations steps in Pentaho DI vs SQL Oracle

    I have a question about ETL with Pentaho DI.

    When designing an ETL we can do data transformation steps in database (procedures or SQL) and we can do this steps in a ETL tool like Pentaho DI, as...
  16. Reusing input steps in Pentaho DI (extrenal file or database table)

    I have some input steps that I am going to use in several transformations in a DWH ETL.
    Some of them read data from files and other from database tables.
    I would like to reuse this...
  17. Anybody has connected Pentaho and Cloudera, is that possible?

    Nobody has connected Pentaho and Cloudera??

    Is it possible in Community Edition?, do I hace to use Enterprise Edition?

    Thanks
  18. Some little advances...

    Hi,

    I have made few advances., but it still doesn't work...

    This site has been helpful: https://cheranilango.blogspot.com.es

    There were some configurations files needed:
    ...
  19. Error connecting Pentaho with Cloudera

    Thanks marabo, I have restarted several times the VM, but the error reamains..

    It not seem to be a temporal problems in datanode
  20. Connecting Pentaho DI to Cloudera MV (problems reading file)

    Hi,

    I am tryng to read a file from HDFS in Hadoop from Pentaho DI and I am getting problems:

    - Pentaho DI (open source) in a local machine Win 7 version 6.1
    - HDFS in a Virtual Machine...
  21. Pentaho Data Integration and Gartner magic quadrant data integration tools

    I would like to know why Pentaho DI is not in magic quadrant data integration tools: https://www.gartner.com/doc/3102119/magic-quadrant-data-integration-tools.
    ...
  22. connection to database for the whole session

    Hi,

    I am working with Pentaho Data Integration Community.

    I am creating a transformation and I create a database connection to a MySQL database. The connection works well, but when I create a...
  23. Using environment variables in a filter step

    Hi,

    I am using the "filter rows" step: Flow -> filter rows

    I would like to use a environment var in the filter rows, a condition like that

    field = ${var}

    Is that possible??
  24. Delete in a previous script of a data load to fact table

    Hi,

    I am doing an ETL process to load a fact table. Before to the insert in the fact table I need to do a delete like this:

    DELETE FROM.......WHERE SALES_DATE >= ${v_start_p_date} AND...
  25. Replies
    0
    Views
    746

    ETL incremental load strategies

    Hi,

    I would like to know which is the best strategy in a ETL incremental load.
    I have a CDC system that capture changes that I read, validate, transform and load in the target DB.
    These...
  26. Debugging Pentaho: select some steps to execute in a transformation

    Hi,

    I have a very simple question....(newbie)

    I have a transformation with 8 steps, and I am havinf an error. I would like to execute only the 4 first setps...is it possible??

    I disconnect...
  27. Replies
    0
    Views
    994

    DataCleaner doesn't launch

    Hi,

    I have downloadede the plug-in from https://pentaho.box.com/s/rslfm6ksa57evaxpwraq and unzip into the folder data-integration\plugins\spoon
    PDI/Kettle Version 5.3

    I have installeed from ...
  28. Differences between partitioned and clustered execution

    Hi,

    I have defined 3 schema partitions in my ktr and I am using it in some steps using partitions (option of ktr), I am using the 'Remainder of division' type. It works well.

    I haven't made...
  29. Replies
    3
    Views
    737

    Thanks Marabo Of course you can import from...

    Thanks Marabo

    Of course you can import from jar files. Look at the samples provided with Kettle in your installation folder or here in the forum.
    Regarding complex business logic: Don't do that...
  30. Replies
    3
    Views
    737

    Using user defined java class

    I am using the user defined java class in a pentaho DI.
    I find it useful because you can use java code, but hard to ue.
    f you have to code s complex business logic, how do you test your code?, can...
  31. Schema Workbench working with aggregated tables

    Hi,

    I am a newbie using Schema Workbench. I have defined a cube with the classical star schema (fact and dimensions).
    I have one fact table, I want to define some aggregated tables over that...
  32. Replies
    0
    Views
    506

    Question about autodoc

    Hi, I am using "Automatic Documentation Output"

    I have selected all the doc options to have a detailed doc.

    I want to have a doc at step level, is it possible??

    I don't find many places to...
  33. Replies
    1
    Views
    607

    Question about "data validator" step

    I am using "data validator" step to validate data types and length of fields i my job.
    When this step detect a wrong validation it generates an error...is is possible to use data validator to...
  34. Question about debugging jobs and transformation

    I have a question about debug a job.

    I have a job with 3 transformations. The dataset results of each transformation have to be passed to the next transformation.
    I used the step "copy rows to...
  35. Replies
    3
    Views
    588

    Ok, thanks Why is not popular?, bad...

    Ok, thanks

    Why is not popular?, bad performance?, any problems?, let me know, please.
    I am considering using it
  36. Replies
    3
    Views
    588

    CWM estandar in Pentaho DI

    Hi,

    I want to know if it's possible to use metadata of a ETL process made in other ETL tool in Pentaho DI.
    This metadata is exported in CWM estandar.

    Thanks in advance,
  37. Replies
    0
    Views
    437

    Data linegje in Pentaho DI

    Hi,

    Is it possible to do data lineage in PDI??

    I found in the input fields of a transformation, the origin step of each field.

    Can you get more information?

    Thanks
  38. Thanks, it helps me. The reason to want the loop...

    Thanks, it helps me.
    The reason to want the loop at transformation level is to use it in another jobs
  39. Thanks gutlez, If it is not possible al job...

    Thanks gutlez,

    If it is not possible al job level I will do there. How do I do a loop al job level, using conditions?

    Thanks
  40. Thanks gulez I want to make some steps for the...

    Thanks gulez

    I want to make some steps for the rows of each period(YYYYMM) in a file. I repeat the same steps (changing few things) for each period y want to make a loop from 201501 to 201506.
    Is...
  41. How to do a loop in a transformation (ktr)

    Hi,

    I want to know how to make a loop process (repetitive process) in a ktr pentaho transformation.
    I don't find any predefined task (like sorting, import, validation..) to do this.

    Thanks in...
  42. Replies
    1
    Views
    557

    Questions about jobs executing in PDI

    Hi,

    I have two questions about jobs in Pentaho Data Intehration.

    1) When I am working with transformation I have the option of executing until one step and preview the data of the stream al...
  43. Problem create¡ing a data source to MySQL in Pentaho User Console

    Hi,

    I am working with Pentaho B.A platform.

    I want to create a data source from the Pentaho User Console. It's a data source to a MySQL database.

    I have to select 'Generic Database' (there...
  44. Connecting Pentaho DI to Microsoft SQL Server azzure

    I make a connection like that:


    engine: sqlserver
    port: 1422
    host name: machine_name.database.windows.net
    database name: database_name


    And I got his error:
  45. Thanks!!

    Using kitchen.sh is possible and easy
  46. It works...

    It works very well, thanks
  47. Connecting data streams between transformations in a job

    Hi,

    I have made a job with some transformation, I want to use in tr2 the output data stream of tr1, I can write and read a file, but I want to know if ther is a component or a way to connect data...
  48. Replies
    4
    Views
    1,306

    scheduling pentaho job

    Hi,

    I want to know which is the best way to schedule a pentaho job in unix.

    I want tu run a pentaho job in a unix server via .sh.

    Do i need pentaho to be installed in the server?
    Can I get...
  49. Thanks

    Thanks for your help
  50. Replies
    1
    Views
    469

    Loading a database table in PDI

    I am creating a tranform in PDI whose last step is a load step to a Mysql table.
    It is possible that mysql don't exists, is there any option to create it (DDL create table) in the pentaho loading...
Results 1 to 50 of 57
Page 1 of 2 1 2
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

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