SOURCE
NAME SAL
GANGA 30000
RAJU 20000
PAVAN 25000
TARGET
NAME SAL MAXSAL
GANGA 30000 30000
RAJU 20000 30000
PAVAN 25000 30000
in mapping level how to achive that
- 5 Answers
- 9682 Views
- DELL, I also Faced
- E-Mail Answers
Answer Posted / davankumar
select name,sal,(select max(sal) from t1) from t1
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Explain sessions and how many types of sessions are there?
How to Create a folder using pmrep command?
Plz can any one say me how to get the informatica certification materials and dumps
What is domain in terms of informatica?
How to convert multiple rows to single row (multiple columns) in informatica
can any one give some examples for pre sql and post sql(Except dropping and creating index).
What is a repository manager?
wat are deployement groups in informatica, how it will be used for developers
How do you remove duplicate records in informatica? And how many ways are there to do it?
What is an aggregator transformation?
In informatics server which files are created during the session rums?
What does cheating measurement mean?
How identifying bottlenecks in various components of informatica and resolving them?
How to load data in informatica ?
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?
