This content has been marked as final. Show 10 replies
you need create a table "WRK_COMPLEXITY" with only a column with your three value. Map it in ODI and import into your interface. Then make a full join.
Here a topic really similar to your
How to use "full join" in ODI interface
here the docs.
let us know
1) Create a file and put your 3 values on seperate lines.
2) Save it to alocation accessible from ODI.
3) Then in the ODI designer create a model based on that file i.e. reverse engineer it.
4) Then in the interface where you are loading your original data, drag in the new model as a 2nd source and perform a cross join between your 2 models to get the cartesian product of the 2 i.e. a line for each row in your first source model x each row in your 2nd model
5) Map to your target model
Another approach would be to use the SQL as Select IKM and simply union your 12 values together as a temporary interface, then use this interface with a full join back into your original interface.
see here :
This way you wouldnt need to deploy additional tables / files etc, and its all maintainable from within ODI.
if you click on the sub_complexity column in the target pane, you see the mapping implementation in the Property Inspector.
For example case ( sub)
when sub =' eng' then 'eng_tough'
you can use others SQL or PL/SQL functions .
Let us know
Edited by: zoran_2000 on 14-mei-2013 12:25