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
- 8236 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / gd
select max(sal) from table a,table b in (select
a.id,a.name,a.sal,b.id.b.sal from table a, tableb where
a.id=b.id);
| Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
define galaxy repository in informatica
What is joiner transformation?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
Enlist the tasks for which source qualifier transformation is used.
In development project what is the process to follow for an etl developer from day1
my source is junk data how will u remove that junk data by using unix please any one replay me
what is $$$$?
Whats the difference between informatica powercenter server, repositoryserver and repository?
Difference between Target-based loading and constraint-based loading?
what is INFORMATICA TESTING process
What is mapping debugger?
Explain in detail about scd type 1 through mapping.
Define the various join types of joiner transformation?
If informatica has its scheduler why using third party scheduler?
Which files are created during the session rums by informatics server?
