Answer Posted / maj
In this select query I think instead of LEFT OUTER
JOIN,Need to put "RIGHT OUTER JOIN"
SELECT * FROM employees LEFT OUTER JOIN departments ON
(employees.department_id = departments.department_id)
Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
can we override a native sql query within informatica? Where do we do it? How do we do it?
What are the different transaction levels available in transaction control transformation?
What is domain in terms of informatica?
Explain pushdown optimization and types in informatica
What are the types of schemas we have in data warehouse and what are the difference between them?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
What is a sequence generator transformation?
What are the limitations of joiner transformation?
What is meant by query override?
What is enterprise data warehousing?
What is an Integration service in Informatica?
How to use pmcmd utility command?
What is different between the data warehouse and data mart?
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
What is rank transformation in informatica