CODEWITHSUNDEEP
javaoracle-databaseoracle-data-integrator
Steve
Steve

Reputation: 38

Getting Mapped column names in knowledge module

I need to get the the specified mapped column names only, I tried using <%=odiRef.getColList("", "[CX_COL_NAME]",",", "","")%> and <%=odiRef.getColList("", "[EXPRESSION]", "~~", "")%> but both returns all the column names instead of the particular mapped column.

Even after mapping just one column to another, what I am receiving is all the fields mapped against another.

Any help would be highly appreciated. Thanks in advance.

Upvotes: 0

Views: 398

Answers (1)

B.I. MartinGo
B.I. MartinGo

Reputation: 1

Try using odiRef.getTargetColList()

According to ODI Documentation

Use to return information about the active attributes of the target table of a mapping. Active attributes are those having an active mapping.

It shoould bring the list of attributes that have mapping only. But you won't get the epression. You can see detailed doc in

https://docs.oracle.com/middleware/1212/odi/ODIKD/odiref_reference.htm#ODIKD1300

Upvotes: 0

Related Questions