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
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
How big was your fact table
What is an expression transformation in informatica?
Whats the difference between informatica powercenter server, repositoryserver and repository?
what is the -ve test case in your project.
What are the components of workflow manager?
What is meant by a domain?
Enterprise data warehouse your projects phase by phase explain?
If informatica has its scheduler why using third party scheduler?
What are the new features of informatica 9.x in developer level?
What are the designer tools for creating transformations?
What can we do to improve the performance of informatica aggregator transformation?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
I have a flat file, want to reverse the contents of the flat file