1.How to create ETL code which will behave same as case statement in Database. Name the component which you will use for the same. 2.Can we run the ETL code until the condition met or you can say infinite loop like while statement saying 1==1 in shell script. 3.How to get number of fields in csv file in Pentaho without using shell Script. 4.Have you ever used Sample rows component. If yes, where you actually need this component. 5.What is Apache kafka . How you will setup the same in…
Month: June 2019
Check Number of fields in csv file in Pentaho
Today, I will discuss about the “How to check Number of fields in csv file or any other file in Pentaho without using shell Scripting. Below is the code snippet for the same. Here, we have used components like Text file input, Sample rows, Split fields to rows,Write to log. In Text File input, we have intentionally kept wrong delimiter, so that we will get only one field in the fields section. Please see how data looks like. Now, comes the Sample rows,Using this component, we will fetch only one…