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


Please Help Members By Posting Answers For Below Questions

Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?

634


What is dynamic cache?

614


Whats the difference between informatica powercenter server, repositoryserver and repository?

679


What are multi-group transformations?

566


How to join three sources using joiner? Explain though mapping flow.

704






What is deployment group?

690


What is DR strategy for Informatica project?

706


Tell me any other tools for scheduling purpose other than workflow manager pmcmd?

742


How to extract the informatica rejected data?

757


What is Index Caches size?

625


How to elaborate powercenter integration service?

652


What is workflow monitor?

603


What is joiner transformation in informatica?

629


where to store informatica rejected data? How to extract the informatica rejected data?

607


What are the static cache and dynamic cache in informatica?

720