Fiz Conforme mostrado na Aula https://cursos.alura.com.br/course/pentaho-data-integration-transformacao-com-etl/task/50703 nos 12:01 minutos na hora de executar o processo para Gravação na Tabela Cliente, apresentou esses erros :
2022/07/06 16:01:38 - Spoon - Running transformation using the Kettle execution engine 2022/07/06 16:01:38 - Spoon - Transformation opened. 2022/07/06 16:01:38 - Spoon - Launching transformation [DimensaoCliente]... 2022/07/06 16:01:38 - Spoon - Started the transformation execution. 2022/07/06 16:01:39 - DimensaoCliente - Dispatching started for transformation [DimensaoCliente] 2022/07/06 16:01:39 - Leitura de Regioes.0 - Header row skipped in file 'c:\treinamento\ProjetoSucos\BusinessIntelligenceSucos\arquivos\REGIOES DOS ESTADOS.csv' 2022/07/06 16:01:39 - Leitura de Regioes.0 - Finished processing (I=10, O=0, R=0, W=9, U=0, E=0) 2022/07/06 16:01:39 - Leitura Planilha de Clientes.0 - Finished processing (I=57, O=0, R=0, W=57, U=0, E=0) 2022/07/06 16:01:39 - Split Cliente.0 - Finished processing (I=0, O=0, R=57, W=57, U=0, E=0) 2022/07/06 16:01:39 - Split Endereco.0 - Finished processing (I=0, O=0, R=57, W=57, U=0, E=0) 2022/07/06 16:01:39 - Dimensao Cliente.0 - ERROR (version 9.3.0.0-428, build 9.3.0.0-428 from 2022-04-12 04.56.25 by buildguy) : Unexpected error 2022/07/06 16:01:39 - Dimensao Cliente.0 - ERROR (version 9.3.0.0-428, build 9.3.0.0-428 from 2022-04-12 04.56.25 by buildguy) : org.pentaho.di.core.exception.KettleStepException: 2022/07/06 16:01:39 - Dimensao Cliente.0 - The same column can't be inserted into the target row twice: Cod_Regiao 2022/07/06 16:01:39 - Dimensao Cliente.0 - 2022/07/06 16:01:39 - Dimensao Cliente.0 - at org.pentaho.di.trans.steps.insertupdate.InsertUpdate.processRow(InsertUpdate.java:280) 2022/07/06 16:01:39 - Dimensao Cliente.0 - at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62) 2022/07/06 16:01:39 - Dimensao Cliente.0 - at java.lang.Thread.run(Unknown Source) 2022/07/06 16:01:39 - Juntando Clientes com Regiao.0 - Finished processing (I=0, O=0, R=54, W=45, U=0, E=0) 2022/07/06 16:01:39 - Dimensao Cliente.0 - Finished processing (I=0, O=0, R=1, W=0, U=0, E=1) 2022/07/06 16:01:39 - DimensaoCliente - ERROR (version 9.3.0.0-428, build 9.3.0.0-428 from 2022-04-12 04.56.25 by buildguy) : Errors detected! 2022/07/06 16:01:39 - Spoon - The transformation has finished!! 2022/07/06 16:01:39 - DimensaoCliente - ERROR (version 9.3.0.0-428, build 9.3.0.0-428 from 2022-04-12 04.56.25 by buildguy) : Errors detected! 2022/07/06 16:01:39 - DimensaoCliente - ERROR (version 9.3.0.0-428, build 9.3.0.0-428 from 2022-04-12 04.56.25 by buildguy) : Errors detected! 2022/07/06 16:01:39 - DimensaoCliente - Transformation detected one or more steps with errors. 2022/07/06 16:01:39 - DimensaoCliente - Transformation is killing the other steps!
(
)