source target
--------- --------
name no sal name no sal max_sal
r 10 1000 r 10 1000 3000
y 20 3000 y 20 3000 3000
Answer Posted / james
Hey Babu,
I've tried your query.
It's not working for me.
Please double check it.
And u said my query doesn't work.
It works absolutely fine for me.
Please let me know where my went wrong.
Waiting for your reply.
-James
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are mapplets?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
What is persistent lookup cache?
How identifying bottlenecks in various components of informatica and resolving them?
How to join three sources using joiner? Explain though mapping flow.
what is INFORMATICA TESTING process
What is enterprise data warehousing?
What is the difference between a connected look up and unconnected lookup?
update strategy transformation in informatica
Explain lookup transformation in informatica
What is resilience time?
Describe data concatenation?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
What is a joiner transformation and why it is an active one?
Global and Local shortcuts. Advantages.