Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 5 Answers
- 7082 Views
- I also Faced
- E-Mail Answers
Answer Posted / sarat
In EXP take
2 variable ports
name1 = substr(name,instr(name,'_',1,1)+1)
name2 = concat('_',substr(name,1,instr(name,'_',1,1)-1))
1 O/p port
result = concat(name1,name2)------> this is ur o/p
I wish it works, if any problem occurs,
take '_' as 3rd variable name3 and
concat(name3,name2)
concatenate the result with name 1
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
Which files are created during the session rums by informatics server?
What are the features of complex mapping?
Different qualification between a related rotate toward the sky and isolates look upward?
What are the different types of olap? Give an example?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
In warehouses how many schemas are there?
What are the databases that informatica can connect to windows?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
what is INFORMATICA TESTING process
How do you load first and last records into target table?
Is stop and abort are same in informatica?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
How to extract sap data using informatica? What is abap? What are idocs?
Parameter and variable differences
