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
- 9511 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / dinesh
select max(sal) from (select max(sal) as sal from table a)
union
(select max(sal) as sal from table b)
ans:
sal
7000
6000
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
How to create Target definition for flat files?
Explain what are the different types of transformation available in informatica.
What are connected or unconnected transformations?
Why sorter is an active transformation?
What are the issues you have faced in your project? How did you overcome those issues?
Enlist some properties of sessions.
Which transformation is needed while using the Cobol sources as source definitions?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
Describe an informatica powercenter?
Explain the tuning lookup transformation - informatica
How do you set a varible in incremental aggregation
Slowly changing dimensions, types and where will you use them
Explain the difference between mapping parameter and mapping variable?
What is intricate mapping?
Which are the different editions of informatica powercenter that are available?
