Interested to Buy Any Domain ? << Click Here >> for more details...
write a query to get maximum salary from the employers table
without duplicates....kindly help me
- 5 Answers
- 10037 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / deva
select (distinct max(sal)) from emp
group by sal.
When ever you use goupfunctions in select statement grup by clause is must.....other wise it will throw an error
| Is This Answer Correct ? | 8 Yes | 13 No |
Post New Answer View All Answers
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
What is meant by lookup transformation? Explain the types of lookup transformation?
Explain pmcmd command usage in informatica
Please let me know how to make Data masking in informatica..
What is a connected transformation?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
How many transformations can be used in mapplets.
What is transformation?
How to go to the older version for a mapping?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
EXL informatica Questions
Have you worked with/created Parameter file
How to extract sap data using informatica?
How can we store previous session logs?
Separate from a database, an information bazaar, and an information stockroom?
