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
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
What is dynamic cache?
Whats the difference between informatica powercenter server, repositoryserver and repository?
What are multi-group transformations?
How to join three sources using joiner? Explain though mapping flow.
What is deployment group?
What is DR strategy for Informatica project?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
How to extract the informatica rejected data?
What is Index Caches size?
How to elaborate powercenter integration service?
What is workflow monitor?
What is joiner transformation in informatica?
where to store informatica rejected data? How to extract the informatica rejected data?
What are the static cache and dynamic cache in informatica?