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
- 8613 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
What is informatica metadata and where is it stored?
How do you convert single row from source into three rows into target?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
Which development components of informatica have the highest usage?
how many types of dimensions are available in informatica?
Differentiate between joiner and lookup transformation?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
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.
How might one distinguish in the case of mapping is right or not without associating session?
What is olap (on-line analytical processing?
what is the complex transformation you used in informatica
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
How do you change a non-reusable transformation to reusable transformation?
While migrating the data from one environment to another environment how would you manage the connections?
whats the logic to load the lower level of granularity of data to fact table.
