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
The correct approach but you don't need to explicitly create a table just put the 3 names in a file,create a model for it and add as your 2nd source then do the join.
I did not understood your response. I am sorry can you please explain it in detail.
Thanks for the reply. I just gave an example with 3 values but actually I have 4 subjects and totally 12 values i. e 3 for each subject. I am not allowed to create any table to achieve this. So, is there any way to do this without creating a table.
Instead of using a table he's suggesting to you to use a flat file :D
then use a flat file with 2 column, delimited by | for example with your data.
and so on
Edited by: DecaXD on May 9, 2013 8:50 AM
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
Thanks for your response and can you explain the 4th point in detail. I am not able to implement it. One more thing is I have 12 columns that should be added to 4 rows.
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
just follow this to your interface mapping expression.
Use case for sub_complexity column
use link for more :