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
- 9675 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
What is sq transformation?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
As union transformation gives UNION ALL output, how you will get the UNION output?
what is the complex transformation you used in informatica
What are the new features of informatica 9.x at the developer level?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
Define joiner transformation?
What is a filter transformation?
What does command task mean?
Performance tuning in UNIX for informatica mappings?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
How do you handle two sessions in Informatica
Can we create two repositories on same database instance in oracle?
Can informatica load heterogeneous targets from heterogeneous sources?
