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 load a Dimension ? and how to load a fact table?
Have you worked with/created Parameter file
Explain sessions?
tell me about your project functionality
How to handle decimal places while importing a flatfile into informatica?
How can we use mapping variables in informatica?
What are the types of schemas we have in data warehouse and what are the difference between them?
What's the layout of parameter file (what does a parameter file contain?)?
Explain the informatica workflow?
State the limitations where we cannot use joiner in the mapping pipeline?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
What are the main issues while working with flat files as source and as targets ?
What all join we can perform in LOOKUP transformation?
How can one identify whether mapping is correct or not without connecting session?
What are the performance considerations when working with aggregator transformation?