Invoking an select script through ODI -Cons and error logging

Hello All,

I am wondering about below 2 options:

Option 1:

I have select script handy with me which fetch data by joining many source tables and performs some transformations like aggregations (group by), data conversion, sub-string etc.

Can I invoke this script through ODI mapping and return results (transformed data output) can be inserted into target of ODI mapping ?

Option2:

Convert the select script into equivalent ODI mapping by using equivalent ODI transformations , functions , look ups etc and use various tables (tables in join clause) as source of mappings.

Basically develop ODI mapping which is equivalent to provided select script plus a target table to insert records into it.

I need to know pros and cons of both options in above (if option 1 is possible).

Is it still possible to track transformation errors, join source tables and where clause condition related errors etc through ODI with option 1?

Log file for mapping failure will have as granular level details as offered by option 2?

Can I still enable Flow Control at Knowledge Module and redirect select script errors into E$_ error tables provided by ODI?

Thanks,Rajneesh

rajneesh4u

posted on 08 Apr 20