Data in one column looks like this 00003242-2-0-1, 00000925-1-0-1, 00003214-2-0-1. In target I need to get only data like 3242, 0925, 3214 in different row
I am using Informatica PC. I have workflow which have sql query. This query like "select t1, t2, t3 from table where t1 between date '2020-01-01' and date '2020