We can follow anyone of the following to create a subquery.
1. Using the Yellow interface and sub-queries option we can create subqueries in ODI.
2. Using a VIEW we can go for subqueries.
3. Using ODI Procedure we can call direct database queries in ODI.
Posted Date:- 2021-10-08 05:10:12
How to load valid records into one table and invalid records into another table?
What are different ways to promoting code ?
How promote code from one environment another environment?
What is meant by load balancing and how to do setup for it?
What is sequence and different types of Sequence available in ODI?
Can we reverse engineer Flat Files?
Different types of Reverse Engineering?
What are the prime responsibilities of the Data Integration Administrator?
What is a procedure and how to write the procedures in ODI?
What systems can ODI extract and load data into?
How to reverse engineer views(how to load the data from views)?
How to load the data with one flat file and one RDBMS table using joins?
How to implement data validations?
How to write the sub-queries in ODI?
Does ODI support web services?
Explain step-by-step procedure to enable Journalization?
How to pass a variable more than one values?
What is Journalization and why we are using it in ODI?
What do you mean by "moving data" ?
How to tune a mapping in ODI ?
What are the types of data quality control?
What is SKM and when we will use this SKM?
Explain some differences between ODI 10g and ODI 11g?
What are the types of Knowledge Modules?
Can I create more than one Master Repository in ODI?
how to prevent overwrite existing data in table
Is it possible to place a variable as a parameter in an API Reference?
I'd like to ask if it possible to use a stored procedure (maybe in cursor) as a data source?
We have an options recyle_errors on target table Flow tab. how exactly it works?