Can you joined two sources without common column?



Can you joined two sources without common column?..

Answer / Sadiya Rahman

Yes, you can join two sources without a common column in ODI by using a lookup transformation. The Lookup transformation reads data from one source (lookup table) and matches it with data in another source (main table) based on a condition, even if there is no common column between them.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Data Integrator (ODI) Interview Questions

What is the data quality in odi?

1 Answers   TCS,


What is the load plans? And how to create for the load plans?

1 Answers   Infosys,


What is package and main advantages?

1 Answers   Accenture,


suppose having unique and duplicate but I want to load unique record one table and duplicates one table?

1 Answers   Hexaware, Seventhsense Technologies,


What are the IKM types?

1 Answers   Virtuas,


Have you created fact table and dimension tables?

0 Answers   Virtuas,


When you used JKM ?

1 Answers   Virtuas,


What is memo?

1 Answers   Accenture,


What is a scenario in odi?

1 Answers   Accenture,


What is Journalization and why we are using in ODI?

1 Answers   Accenture,


What is Session Tasks?

1 Answers   Seventhsense Technologies,


What is CKM and when we will use this CKM?

1 Answers   Accenture,


Categories
  • Oracle General Interview Questions Oracle General (1803)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)