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
What could be the possible resons of locks by user?
Differentiate between source qualifier and filter transformation?
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
What is meant by pre and post session shell command?
How can we use mapping variables in informatica?
what is the -ve test case in your project.
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.
can you please explain me pre session and post session options?
is it possible to index the data in cache of lkp transformation ?
Enlist the advantages of informatica.
Design a mapping to load a target table with the following values from the above source?
What are the tasks that source qualifier perform?
What is meant by query override?
update strategy transformation in informatica
Informatica settings are available in which file?