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
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
Differentiate between reusable transformation and mapplet.
What is standalone command task?
Can we create two repositories on same database instance in oracle?
Define joiner transformation?
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
What is option by which we can run all the sessions in a batch simultaneously?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
Explain pushdown optimization $pushdownconfig parameter - informatica
What is domain in terms of informatica?
How big was your fact table
What is a filter transformation and why it is an active one?
What is mapplet in informatica?
wat are deployement groups in informatica, how it will be used for developers
How can we use batches?
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?