Charging and Control Applications (MOSC)

MOSC Banner

How can ODI help me create new tables at the ends of a mapping?

I think this question might be very common, but I cannot find a good solution.

When the flow in a mapping finishes, a new table is created with a selected set of attributes and their corresponding data types. However, I cannot find a way to create that output table automatically. Currently, I have to manually enter every attribute and datatype, which is very error-prone and labor-intensive.

In ODI, if you use the expression component, it is easy to add new attributes by dragging and dropping them. This component also shows the corresponding datatype because it knows the preceding data type from the source tables (datastore).

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center