Hitachi Vantara Pentaho Community Forums

Search Forums:

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

Page 1 of 7 1 2 3 4

Search Forums: Search took 0.02 seconds.

  1. Hi, do you really want to do that???:confused: ...

    Hi, do you really want to do that???:confused:

    if the answer is yes, you should use symmetric Cryptography step. You will need to load the content first.

    for decrypting you only need to change...
  2. Replies
    0
    Views
    613

    hadoop 2.1.1

    hello guys, i've downloaded hadoop 2.8.0 (here is the link http://apache.claz.org/hadoop/common/hadoop-2.8.0/)and apache hive 2.1.1.I was able to connect via console (ubuntu 14.04) and I executed a...
  3. I think is fireChange (parameter,value)

    I think is fireChange (parameter,value)
  4. Replies
    4
    Views
    724

    jira.pentaho.com/browse/CDE-177?page=com.atlassian...

    jira.pentaho.com/browse/CDE-177?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
  5. Replies
    0
    Views
    829

    z/ OS file

    hi guys, I'm working with z/OS file input (this step can read cobol), and I have a question about this glorious step. I saw when I do click on "get fields", this step creates a .jar file. This file...
  6. for info, check the wiki. anyway, the step is...

    for info, check the wiki. anyway, the step is very easy. You have 3 tabs, select &alter, remove, and meta-data. on tab "select & Alter" you can rename fields if you want. the fields that map in this...
  7. use select values.... take a look to metadata's...

    use select values.... take a look to metadata's tab
  8. Replies
    0
    Views
    739

    Pdi 4.2.1

    Hi guys, I'm working with 4.2.1 EE and my scenario is this..

    job: job-->trafo-->other job

    but, for my surprise, when I save my file, and close PDI. The same file can not be open any more. In...
  9. mmmmmmmmmm In these cases use java script , is...

    mmmmmmmmmm In these cases use java script , is the best option for me
  10. depends logic, if the field has separator or has ...

    depends logic, if the field has separator or has fix length, anyway all depends logic. you could use, Java script, strings cut(fix length) or strings operator
  11. Replies
    1
    Views
    1,022

    use select values for map/unmap values, also you...

    use select values for map/unmap values, also you can use this step for change any metadata. In addition you could see the metadata of "entry fields", for do this, right click on table output step...
  12. thanks ato, I'll try that! anyway, what is the...

    thanks ato, I'll try that! anyway, what is the best way to sort rows in pdi without sort row's step?
  13. java.lang.OutOfMemoryError: GC overhead limit exceeded

    hello guys, a I Have a serious problem, I have 4 transformation
    1st,2nd,3th --> table input --> text file output, like this
    4th--> in this one, I toke the files and merge them in this way:
    8574
    ...
  14. te cuento q para usar los parametros de la forma...

    te cuento q para usar los parametros de la forma ${mi_parametro}, deberias setear primero la variable en una transformacion previa.. haciendolo de la manera que estas haciendo vos.. deberias capturar...
  15. ERROR in stream lookup or des-serializefiile

    hi I have the following transformation:
    1 - des-serialize file--> stream lookup<-- des serialize file

    when I execute the transformation, it throws me a weird error...
  16. Replies
    1
    Views
    1,240

    binary file

    hi guys, I have a binary file, how can I do to read a binary file? cuz I tried to read this file with "text file input" but It doesn't work, any ideas?
  17. Replies
    6
    Views
    1,423

    Well guys, this is the end... :P, the mick's idea...

    Well guys, this is the end... :P, the mick's idea it works!, I have only one restriction, I must be winzip in the server, but that is not problem because th server is some windows. thanks a lot...
  18. Replies
    6
    Views
    1,423

    mick, sorry, but I tried to do the script ( I...

    mick, sorry, but I tried to do the script ( I found many options in google), but any works, please could you send me your .bat file??? please :)
    thanks a lot
  19. Replies
    6
    Views
    1,423

    good Idea Mick_data, I will try that! thanks a...

    good Idea Mick_data, I will try that!
    thanks a lot!
  20. Replies
    6
    Views
    1,423

    thanks a lot, I'll see another way to do...

    thanks a lot, I'll see another way to do this...if anyone have an idea please let me know
  21. Replies
    6
    Views
    1,423

    zip file with pass

    hello guys, I have a zip file with pass, is any way to unzip this file?(I have the password)
    Exists a way to do this in PDI. I'm working with PDI 3.2.3 but we will migrate to version 4.1.2
    :o...
  22. Replies
    4
    Views
    1,500

    hi, uses the sentences "like" ... AND...

    hi, uses the sentences "like" ...

    AND FLIGHTNUMBER like '${flightNum}'

    when the variable is empty the defect value must be '%' (put this in a parameter option 'default')
  23. muy buen aporte.. felicitaciones!

    muy buen aporte.. felicitaciones!
  24. Replies
    1
    Views
    2,141

    dos claves primarias? me parece q tenes un error...

    dos claves primarias? me parece q tenes un error de concepto, la clave primaria debe ser UNICA, a lo sumo podes tener un UNIQUE key. si me estas hablando de q la clave primaria esta compuesta por dos...
  25. Replies
    3
    Views
    1,501

    yo te cuento con mi experiencia, puede ser el...

    yo te cuento con mi experiencia, puede ser el navegador... para html o puede ser la version del reader en caso q lo saques en PDF, a mi un cambio de versiones en las maquinas de ese tipo de files me...
  26. que version de PDI estas manejando¡?

    que version de PDI estas manejando¡?
  27. Thread: Md5

    by hernanthiebaut
    Replies
    4
    Views
    1,167

    ok thanks for your replay, the fact is that, my...

    ok thanks for your replay, the fact is that, my client use md5 for encrypt some fields, I understand that md5 is not a way to encrypt data, but, how I can implement md5 in PDI?, java script?...
  28. Thread: Md5

    by hernanthiebaut
    Replies
    4
    Views
    1,167

    Md5

    hello guys, I have a question, exists a way to pass a field from one step to other, and this last step encript the field with md5?, I see the new steps for encrypt from version 4.2 ( oh my god! are...
  29. hasta lo que se con pdi es imposible, te...

    hasta lo que se con pdi es imposible, te recomiendo que charles con tu cliente y propongas alguna solucion en la cual el file varie lo menos posible. Por ej. si se va a ir incrementando cada 4...
  30. your welcome :)

    your welcome :)
  31. perhaps, your work has some errors, however,...

    perhaps, your work has some errors, however, could you try using "merge join" or if the data comes from a database, "database join" step is a good option
  32. Replies
    3
    Views
    989

    Mr google told me this: Error: ...

    Mr google told me this:


    Error:


    ORA-01747: invalid user.table.column, table.column, or columns specification
    Cause:
    You tried to reference a column name, but the column name used is a...
  33. did you try specifing a mask in excel input? or...

    did you try specifing a mask in excel input? or select values?
  34. alex, try using the last tab in select values...

    alex, try using the last tab in select values step (metadata), that is more efficient, also you could use javascript with the function str2num ,
  35. you have never asked for the performance... :P,...

    you have never asked for the performance... :P, let me think another option
    reggards
  36. perhaps, you could create a sequence and...

    perhaps, you could create a sequence and filtering for the number 1? however this is very inefficient, because the sequence runs for every row
  37. Replies
    1
    Views
    777

    try with "get system info" step, in the second...

    try with "get system info" step, in the second tab select "system date", later in other step,use some filter the date and keep the year
  38. Replies
    4
    Views
    1,453

    mariarita, the sql sentences must be not ok,...

    mariarita, the sql sentences must be not ok, please check the sql senteces with an "sql developer" or another tool of sql, this is not an error from table input or table output
  39. Replies
    4
    Views
    1,592

    have you tried with changing the sentence...

    have you tried with changing the sentence "distinct" to "group by" and grouping for the same fields? anyway I have done many querys with "distinct" sentence
  40. Replies
    1
    Views
    763

    mariarita... the text inside "table input" must...

    mariarita... the text inside "table input" must be a simple "select" sentence of sql . if you are trying to do that, the query is correct
  41. Replies
    7
    Views
    2,850

    you could use java script to transform date to a...

    you could use java script to transform date to a number, use first the function date2Str and for last the function str2Num
  42. seria algo asi name_file_${date}, donde name_file...

    seria algo asi name_file_${date}, donde name_file es en nombre del archivo fijo.. y ${date} es la variable. Recuerda que la variable date debe ser seteada en una previa transformacion... NO EN LA...
  43. Replies
    6
    Views
    1,129

    sorry, but perhaps could you use "database...

    sorry, but perhaps could you use "database lookup" and enable the option "change number of copy to start".
    In this way, my work runs in only 11 sec (before: 87 sec, "using stream lookups")
  44. Replies
    7
    Views
    2,850

    weird.... try to use metadata, and change the...

    weird.... try to use metadata, and change the format.
  45. Replies
    1
    Views
    1,089

    probaste hacerlo desde un SQL script mediante el...

    probaste hacerlo desde un SQL script mediante el comando "call"???
  46. Thread: Table

    by hernanthiebaut
    Replies
    6
    Views
    1,186

    yes, use the funtion "lookup" and set the out...

    yes, use the funtion "lookup" and set the out value for each in value
  47. Replies
    2
    Views
    996

    use the step "set variables", and then use them...

    use the step "set variables", and then use them in the conetion like any variable, ej: ${server}
  48. de nada, disculpa que no fui muy especifico pero...

    de nada, disculpa que no fui muy especifico pero en el trabajo no tengo una consola como para verla e indicarte.. saludos
    Hernan
  49. hay dos archivos xml. uno llamado index, y el...

    hay dos archivos xml. uno llamado index, y el otro no recuerdo bien ahora, y no poseo el server. fijate que esos dos files esten dentro de cada carpeta porque sino la solucion no te los va a dejar...
  50. lo deberias poner dentro de alguna carpeta creada...

    lo deberias poner dentro de alguna carpeta creada en pentaho solutions, fijate q la carpeta este visible en la definicion del xml
Results 1 to 50 of 323
Page 1 of 7 1 2 3 4
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

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