ODI LKM Options

[rahulsony111]

We need you to create a new knowledge module based on LKM SQL to MSSQL that will build its work table based on the target table instead of the source in terms of the column definitions. The problem we are facing is that the current LKM uses the source table for the work table and this causes us problems with Unicode when connecting to the AS400's as the AS400 metadata shows char (or varchar) instead of nvarchar even when the data is unicode.

Can anyone explain me what is the issue here and what needs to be done

Attached File(s)

 Interface.bmp ( 2.33MB ) Number of downloads: 2
 Interface_2.bmp ( 2.47MB ) Number of downloads: 0
 Interface_3.bmp ( 2.47MB ) Number of downloads: 0

 

[Steve]

We need you to create a new knowledge module

This reads like a homework or work assignment given to you verbatim. Have you done any research on this issue yourself yet?

Also, the question you're posing sounds like a development issue. I see you posted the question at http://forums.oracle.com/forums/thread.jspa?threadID=985176 on the Oracle ODI forums. I would await an answer there and do some research of your own; a quick google search shows others with character conversion problems.

We do have some notes on data integration at http://www.dba-oracle.com/t_database_integration_tips.htm, but it sounds like you're looking for something specific.

[rahulsony111]

This reads like a homework or work assignment given to you verbatim. Have you done any research on this issue yourself yet?

Also, the question you're posing sounds like a development issue. I see you posted the question at http://forums.oracle.com/forums/thread.jspa?threadID=985176 on the Oracle ODI forums. I would await an answer there and do some research of your own; a quick google search shows others with character conversion problems.

We do have some notes on data integration at http://www.dba-oracle.com/t_database_integration_tips.htm, but it sounds like you're looking for something specific.

I did research on this. According to the issue i understood something but not sure of that.
I just want to know it from experts so that i can find solution for this