BI/Data Engineering Services Provider
Category: ETL
-
TE_7007 Transformation Evaluation Error [<
> [TO_DATE]: invalid string for converting to Date Recently DAC task is failing and we saw below error message in the Informatica session logs. TRANSF_1_1_1> TE_7007 Transformation Evaluation Error [<> [TO_DATE]: invalid string for converting to Date… t:TO_DATE(s:CONCAT(s:CONCAT(s:SUBSTR(s:TO_CHAR(f:220920220000),i:0,i:8),s:’-‘),s:SUBSTR(s:TO_CHAR(f:220920220000),i:9,i:6)),s:’YYYYMMDD-HH24MISS’)]TRANSF_1_1_1> CMN_1761 Timestamp Event: [Wed Aug 17 05:28:22 2022]TRANSF_1_1_1> TT_11132 Transformation [CYCLNS_Trans] had an error evaluating output column [PROMISED_ON_DT]. Error message is [<> [TO_DATE]: invalid string…
-
Matillion – Transformation Job – Component not in valid state.
When the transformation component is not in a green boundary, then the component is not in a valid state, and you can’t see the sample data and also any updates to the transformation job is not validated . Table in In-valid state Table in Valid state When you try to view sample data of the…
-
BI Engineer/Data Scientist/Data Analyst Role Skills
IMO, the 65-70% of responsibilities and skill sets required for BI Engineer, Data Scientist, and Data Analyst overlap. To become successful in any of the above roles, you will need to know at least the following skills. 1. Business knowledge: You should have sound business knowledge of the company you are analyzing the data. You need…
-
Essbase Cube Data Load – Error 1003000 – Unknown Item in Data Load
We frequently get above error during data load in Essbase using Rule files and Maxl scripts. The reason for it is Essbase encountered a field in the data source that it did not recognize. Most comman reason we encountered for this error is a new value ( eg. Customer, Product etc.) is added on the…