You are not logged in.
Need help to implement the below.
1. we are getting data feed in a file
2. we just need to filter out rows with valid product codes
- valid product codes are available in our database table
3. push the rows with valid product codes to the staging table
Tried tFilterRows component, thank you.
I fear some of the values are truncated while converting bigdecimal to int using one of the methods - toIntValue() or toIntValueExact(). So not sure how to proceed further.
Instead load the data into a staging table and get only non zero values in query panel.
Advice if the above method is right or could I have tune this better.