how to connect two or more table with single source qualifier?
Answer Posted / rampriya
Create a Oracle source with how much ever column you want
and write the join query in SQL query override. But the
column order and data type should be same as in the SQL query.
| Is This Answer Correct ? | 1 Yes | 7 No |
Post New Answer View All Answers
Name at least 5 different types of transformations used in mapping design and state the use of each.?
What is the Rank index port in Rank transformation?
Differentiate between Load Manager and DTM?
What is a snowflake schema?
What is an unconnected transformation?
What is different between the data warehouse and data mart?
How to call shell scripts from informatica?
Explain the etl program with few examples.
Explain the different kinds of facts.
tell me 5 session failure in real time how can you solve that in your project?
What are the modules in Power Center
Differences between connected and unconnected lookup?
How does a sorter cache works?
What are the different types of transformation available in informatica.
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?