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 / sivaramakrishna
boss am not getting i have tried as u said
thank you
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Explain the types of lookup transformation?
How you know when to use a static cache and dynamic cache in lookup transformation?
What is the difference between STOP and ABORT options in Workflow Monitor?
Which development components of informatica have the highest usage?
where to store informatica rejected data?
How will the document be delivered to me?
whats the logic to load the lower level of granularity of data to fact table.
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
How to generate sequence numbers without using the sequence generator transformation?
permutations of mapplet
How do you load unique records into one target table and duplicate records into a different target table?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
How we can create indexes after completing the load process?
What are 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?