⟩ Can we look-up a table from source qualifier transformation. ie. unconnected lookup?
You cannot lookup from a source qualifier directly. However, you can override the SQL in the source qualifier to join with the lookup table to perform the lookup.
Question and Answer:
Home Oracle ETL
- Share
Popular Answers:
* There is no answer to the above question yet.
More Questions for you:
How to avoid using cursors? What to use instead of cursor and in what cases to do so?
State the difference between implict and explict cursors?
How to know the last executed procedure?
How can a function retun more than one value in oracle with proper example?
If the application is running very slow? At what points you need to go about the database in order to improve the performance?
What is the basic structure of PL/SQL?
What are the components of a PL/SQL block?
What are the datatypes a available in PL/SQL?
What are % TYPE and % ROWTYPE? What are the advantages of using these over datatypes?
What is difference between % ROWTYPE and TYPE RECORD?
