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
- 9621 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
Explain what transformation and how many are there in informatica?
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
What is the cumulative sum and moving sum?
What is complex mapping?
What is a dimensional model?
What is the format of informatica objects in a repository?
What are the advantages of using informatica as an etl tool over teradata?
What are roles and groups and benefits of using them?
Explain the different kinds of facts.
How does the aggregator transformation handle null values?
How to generate sequence numbers without using the sequence generator transformation?
How to Create a folder using pmrep command?
What are mapplets?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
