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 |
What is the data quality in odi?
What is the load plans? And how to create for the load plans?
What is package and main advantages?
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?
Have you created fact table and dimension tables?
When you used JKM ?
What is memo?
What is a scenario in odi?
What is Journalization and why we are using in ODI?
What is Session Tasks?
1 Answers Seventhsense Technologies,
What is CKM and when we will use this CKM?