Interested to Buy Any Domain ? << Click Here >> for more details...
follwing scenario two table using find maximum salary?
table a table b
101 xxx 1000 106 6500
103 yyy 5000 108 800
104 din 6000 109 7000
105 dsh 200 110 3000
- 5 Answers
- 9853 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / asdf
select id,name,max(sal) from table a;
select id,max(sal) from table b;
if u want to join two tables
select id,sal from table a,table b where a.id=b.id;
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Define mapping and session?
What are the restrictions of union transformation?
Reusable transformation and shortcut differences
What is the session task and command task?
How many input parameters can exist in an unconnected lookup?
what is the size of u r source(like file or table)?
What is status code in informatica?
Explain direct and indirect flat file loading (source file type) - informatica
if we have a delimiters at unwanted places in a flat file how can we over come those.
Write the unconnected lookup syntax and how to return more than one column.
What can we do to improve the performance of informatica aggregator transformation?
what is song in infrmatica...?
What is the reusable transformation?
What do you understand by SOA of Informatica?
What is meant by lookup transformation? Explain the types of lookup transformation?
