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).