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
- 10059 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / anil kumar
select distinct max(sal) from table name
| Is This Answer Correct ? | 2 Yes | 5 No |
Post New Answer View All Answers
Does an informatica transformation support only aggregate expressions?
What does role playing dimension mean?
where to store informatica rejected data?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
what is the size ur source like(file system or database)? how many record daily come u r banking project?
What is dimensional table?
whats the logic to load the lower level of granularity of data to fact table.
What is domain in terms of informatica?
Can we create a Integration service without a Repository service and vice versa?
What is transformation?
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
What are the different transaction levels available in transaction control transformation?
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
