There is a variable called ETL_HINT_EXTRACT in BIApps 11g.If we want use hints then we need to assign the hints to this ETL_HINT_EXTRACT variable and this need to be used in package like below.
After assigning hints to this variable in package,this value will be substituted in one of the property OBI_HINT_EXTRACT in flow tab like below.
When used in regular IKM this gets applied to the inner query which runs directly against the source when FLOW_CONTROL is not enabled E.g.
insert into W_XXX_XXX
select ...from
(select <OBI_EXTRACT_HINT> from source)
When used in regular IKM this gets applied to the select query on the source for the interface when FLOW_CONTROL is enabled E.g.
insert into I$_...
select <OBI_EXTRACT_HINT> from source
After assigning hints to this variable in package,this value will be substituted in one of the property OBI_HINT_EXTRACT in flow tab like below.
When used in regular IKM this gets applied to the inner query which runs directly against the source when FLOW_CONTROL is not enabled E.g.
insert into W_XXX_XXX
select ...from
(select <OBI_EXTRACT_HINT> from source)
When used in regular IKM this gets applied to the select query on the source for the interface when FLOW_CONTROL is enabled E.g.
insert into I$_...
select <OBI_EXTRACT_HINT> from source
I came across one of the situations where I needed to implement this kind of solution but with different hints. I will try to implement taking this reference... and will see how and what query will be extracted.
ReplyDeleteHi,Were you able to implement multiple hints on the same select statement.
ReplyDelete