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 IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
in reporting we add some new objects,how we get the count of the newly added objects to the report
How do you handle two sessions in Informatica
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
What are the new features of informatica 9.x at the developer level?
Describe an informatica powercenter?
What is meant by pre and post session shell command?
What are the different clients of powercenter?
Under what condition selecting sorted input in aggregator may fail the session?
How to configure mapping in informatica?
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
What are the different ways to implement parallel processing in informatica?
What could be the possible resons of locks by user?