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
- 9681 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
How to open an older version of an object in the workspace?
What is workflow? What are the components of the workflow manager?
What are the mapping parameters and mapping variables?
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
How do you load only null records into target?
What is a stored procedure transformation?
lookup transformation with screenshots
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
Which means the first record should come as last record and last record should come as first record and load into the target file?
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
write a query to retrieve the latest records from the table sorted by version(scd)
scenario where i can use only concurrent execution of workflow.
What is the scenario which compels informatica server to reject files?
What does update strategy mean, and what are the different option of it?
What is olap (on-line analytical processing?
