In this post i will give you a brief idea about a new feature introduced in ODI 12c.
As in informatica now ODI also support SQL query over ride, we can use a custom sql query to over ride the source query.
This feature is available in 12c in Extract option under physical diagram
After creating the mapping navigate to the Physical tab and in Extract Option we can see a feature CUSTOM_TEMPLATE.
In this area we can write a custom select statement and that will be used as a source query for populating the target.
Please remember to map all the fields that in the over ride query from source.
IKM Used: IKM Oracle insert global.
Thank you.
As in informatica now ODI also support SQL query over ride, we can use a custom sql query to over ride the source query.
This feature is available in 12c in Extract option under physical diagram
After creating the mapping navigate to the Physical tab and in Extract Option we can see a feature CUSTOM_TEMPLATE.
In this area we can write a custom select statement and that will be used as a source query for populating the target.
Please remember to map all the fields that in the over ride query from source.
IKM Used: IKM Oracle insert global.
Thank you.
