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
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
Write the program through which the records can be updated?
Under which circumstances, informatica server creates reject files?
Explain joiner transformation in informatica
have u done any performance tuning? how u ll do?
What is meant by LDAP users?
Explain lookup transformation is active in informatica
Where is metadata stored?
What are the informatica performance improvement tips
What are active and passive transformations?
update strategy transformation in informatica
tell me the rules and responsblites in our project(my project is development)
How to create a non-reusable instance of reusable transformations?
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
What are batches?
Separate from a database, an information bazaar, and an information stockroom?