Explain what are the basic needs to join two sources in a source qualifier?
- 1 Answers
- 1284 Views
- I also Faced
- E-Mail Answers
Answer / Shruti Dwivedi
The basic needs to join two sources in a Source Qualifier, also known as ETL tools like Talend or Informatica, are:
1. Common columns: Both sources should have at least one column in common that can be used as the key for the join operation.
2. Data types of the common columns should match or be compatible (e.g., using type casting if necessary).
3. Proper data cleansing and transformation might be required to ensure consistent data before joining.
4. Joins can be performed using various methods, such as inner join, outer join, left join, right join, and full outer join, depending on the desired results.
| Is This Answer Correct ? | 0 Yes | 0 No |
Which parameter specified in the default storage clause of create tablespace cannot be altered after creating the table space?
What is your spectra photometer working principles?
How can we run the graph? What is the procedure for that?
What is the difference between static cache and dynamic cache?
What is the difference between Oracle Express and Oracle Discoverer?
What is the difference between view materialized view and view?
What is difference between model & package?
What is analytical or analytic mean?
what type of raid setup would you put your tx logs?
What is difference between query studio and report studio?
How do we design a universe?
What are the main steps to build the data warehouse?
Teradata 
