Please create a mapping where I have source which has one column with name like Aman_Gupta
Rakesh_Mehra
Sachin_More
I want the target field should contain the name in reverse order i.e Gupta_Aman
Mehra_Rakesh
More_Sachin.
Can you please tell me what transformation would be needed to do this.
Answer Posted / bhagwati
reverse function will return the character string after reversing it.
For e.g. reverse(Aman_Gupta) will return atpuG_namA
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Whats the difference between informatica powercenter server, repositoryserver and repository?
How big was your fact table
1. When u r checking out what ll happens for version no? a. Increase b. decrease c.reset to 0 d. reset to 1 e. no change 2. Salary of all employees needed to add with the commision. What transfrmation to be used? a. SQ and Expression b. SQ c. Update Strategy d. Expression 3. Which of the task is used to run a session based on success of the other session? a. Decision b. Event wait c. Email d. Command e. None 4. Types of sources in Informatica? a. Homogenous n Heterogenous b. None c. Cobol n XML d. Flat files e. Flat files and Homogenous n Heterogenous 5. Servers are available in informatica? a. Informatica Server and Workflow server b. Informatica Server and Informatica Repository Server c. Informatica Server d. Workflow server e. Informatica Repository Server 6. While using Pmcmd in cmd line mode, each command must include the connection info of which of the following? a. workflow manager b. Power Center server c. Workflow monitor d. Repository manager e. Designer 7. Workflow montior displays workflows that have run a. once b. twice c. never d.four times e. thrice 8. Mode for handling sessions n workflows? a. server mode b. Wait mode c. Command line mode d. User mode e. Interactive mode 9. Connection details configured in? a. Mapping designer b. Workflow manager c. Workflow monitor d. Repository manager e. Worklet designer Thanks in Advance
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
What is a joiner transformation and why it is an active one?
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?
How to do unit testing in informatica?
Explain the features of connected and unconnected lookup.
How do you change a non-reusable transformation to reusable transformation?
What is sq transformation?
What is a difference between complete, stop and abort?
How can you validate all mappings in the repository simultaneously?
What is the need of etl tools?
What is an active transformation?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?