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
Enlist the advantages of informatica.
How to create a non-reusable instance of reusable transformations?
Why do we need informatica?
What is the benefit of partitioning a session?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
Why sorter is an active transformation?
What is the function of union transformation?
Explain sql transformation in script mode examples in informatica
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
Describe expression transformation?
What is decode in informatica?
What is the difference between informatics 7x and 8x and what is latest version?
What does reusable transformation mean?
Can we change Dynamic to Static or Persistent cache? If so what happens?