Home » Developer & Programmer » Warehouse Builder » Table Functions (11g)
icon5.gif  Table Functions [message #562353] Tue, 31 July 2012 12:22
naxi
Messages: 2
Registered: July 2012
Junior Member
I would like to use table function in OWB mapping. Table function is inside a package and it already exists in
my database. I imported it and I am able to drag and drop it from Component Palette.
The problem I have is this:

I have a joiner JOINER_A with OUTGRP1:
TASK_DB_ID
TASK_ID
TASK_APPL_CODE

From this joiner I map TASK_APPL_CODE to my GET_APPL_RANGE table function.
TASK_APPL_CODE is a string and it is input parameter for GET_APPL_RANGE table function.
As a RETURN from GET_APPL_RANGE table function I get APPL_GROUP_ID, LOWER_APPL_CD, UPPER_APPL_CD.

Now I have result table RESULT_TABLE that has:
TASK_DB_ID,
TASK_ID
APPL_GROUP_ID
LOWER_APPL_CD,
UPPER_APPL_CD

I am trying to map(insert) TASK_DB_ID and TASK_ID from JOINER_A
and APPL_GROUP_ID, LOWER_APPL_CD, UPPER_APPL_CD from table function into RESULT_TABLE.

But I cannot do that. I get an error:
API8003: Connection target attribute group is already connected to an
incompatible data source. Use a Joiner or Set operator to join the upstream data first before connecting it into this operator.

I was thinking about another joiner between JOINER_A and GET_APPL_RANGE table function, but it doesn't make sense.
Previous Topic: Help! column incompatibility issue during data migration sqlserver-oracle
Next Topic: Update package in Design Center
Goto Forum:
  


Current Time: Sat Aug 23 06:50:09 CDT 2014

Total time taken to generate the page: 0.10004 seconds