Comments by Dhamodharan A

Dhamodharan A 11-Aug-15 2:45am View

HI,
thanks for your response , i did the PENTAHO_JAVA_HOME setup like you mentioned above and after running i got a issue like
C:\Users\dhamodharan.a\Desktop\pdi-ce-4.4.0-stable\data-integration>pan.bat /fil

DEBUG: Using PENTAHO_JAVA_HOME
DEBUG: _PENTAHO_JAVA_HOME=C:\Program Files (x86)\Java\jre7
DEBUG: _PENTAHO_JAVA=C:\Program Files (x86)\Java\jre7\bin\java.exe
WARN 11-08 11:47:09,728 - Unable to load Hadoop Configuration from "file:///C:/
Users/dhamodharan.a/Desktop/pdi-ce-4.4.0-stable/data-integration/plugins/pentaho
-big-data-plugin/hadoop-configurations/mapr". For more information enable debug
logging.
INFO 11-08 11:47:09,759 - Pan - Start of run.
ERROR: No repository provided, can't load transformation.

C:\Users\dhamodharan.a\Desktop\pdi-ce-4.4.0-stable\data-integration>e:C:\Users\d
hamodharan.a\Desktop.test.ktr /level:Basic

Am try to run a input excel file and make the output as excel ,for that also i need to create repository ?
if i try to create repository option i saw only for dbms not for excel and also ,Please clarify my doubt and make it run

thanks in advance

Dhamodharan A 28-Jul-15 5:59am View

u said you having data's in alpha numeric data's, they how you can use int here ?

Dhamodharan A 28-Jul-15 5:36am View

will you please populate some same data and the same output which u need ,Its better for easy understanding

Dhamodharan A 27-Jul-15 5:49am View

You need sql query for single shot insert/delete/update ?

Dhamodharan A 19-Jun-15 6:47am View

use this one will work

UPDATE number
SET num= '39'+''+right(num, Len(num)-2)

Dhamodharan A 19-Jun-15 5:53am View

SO, As per my understanding u need to replace the first two occurrence of 28 to 39 , if suppose 10th row having 55 as starting number u no need to replace ,only the 28 to 39 ..? Am i right ???

Dhamodharan A 19-Jun-15 4:22am View

May i know why you down voted my answer ,whats wrong on that ???

Comments by Dhamodharan A (Top 7 by date)