My Oracle Support Banner

OBIA 7.9.6.X: In Power Center Informatica Why Oracle Function Which Is Called Inside Source Qualifier Always Return 0? (Doc ID 2162103.1)

Last updated on AUGUST 08, 2018

Applies to:

Business Intelligence Applications Consumer - Version 7.9.6.3 [AN 1900] and later
Information in this document applies to any platform.

Goal

Oracle Function gives '0' when used inside a source qualifier (Informatica). However if the same function is called in sql transformation. Why is this behavior?
 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.