Oracle Extract transform load (ETL) Question:
Download Questions 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.

Download Oracle ETL Interview Questions And Answers PDF

Previous QuestionNext Question
What is fact less fact table? where you have used it in your project?Where do we use connected and un connected lookups?