Oracle Extract transform load (ETL) Question: Download Oracle ETL PDF
Can we look-up a table from source qualifier transformation. ie. unconnected lookup?
Answer:
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.
Previous Question | Next Question |
What is fact less fact table? where you have used it in your project? | Where do we use connected and un connected lookups? |