Any alternative function in Informatica for SAP's ISOLA

[Former Member]

Hi ,

In my project we extract data from SAP ECC using BCI mappings.

There is an inbuild function in SAP BW when extracting data from SAP ECC. which is called ISOLA, this is converting LANG code from E to EN and E to ES ( The length of this LANG field is set up 1 not 2 hence its using the conversion function ISOLA)

When we extract the data from SAP ECC for Language we are getting only 1 record which is E rather EN.

Is there any alternative function in Informatica 9.6.1 to do the same conversion before loading into the staging tables.

Regards,

Kannan V

[Former Member]

Hi Kannan,

I don't think Informatica will know the codes that are maintained by SAP. In my project we created a simple view based custom datasource that provided the single digit code and double digit code relation and also the texts for the languages (based on selection input).

Ideally 3 tables are involved in this conversion:

T002 - Main info for 1->2digit lang code

T002X - Language Country Information

T002T - Texts of language

So ideally you can create one more workflow for this data source and manipulate the language later on in staging.

Please let me know if it helps.

Thanks

Amit