'Informatica: Data in column looks like 00003242-2-0-1,00000925-1-0-1,00003214-2-0-1 .In target I need data like 3242, 0925, 3214 in different rows
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 rows. How can I achieve this using informatica mapping?
Solution 1:[1]
Just use a SUBSTR function in an Expression transformation
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | NickW |