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
How to generate sequence numbers?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
Clarify the utilization of aggregator cache record?
What are some examples of informatica etl programs?
Design a mapping to load a target table with the following values from the above source?
Explain why we use partitioning the session in informatica?
How to open an older version of an object in the workspace?
Explain sessions?
Write the advantages of partitioning a session?
Explain the different lookup methods used in informatica?
What are the various types of transformation?
Enterprise data warehouse your projects phase by phase explain?
How do you load unique records into one target table and duplicate records into a different target table?
What is a code page?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?