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
- 7137 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 partition the Session?
Partition, what happens if the specified key range is shorter and longer
What is source qualifier transformation in informatica?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
What are the different lookup cache(s)?
What is blocking transformation?
How to update a particular record in target with out running whole workflow?
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
How many ways are there to do 'remove duplicate records in informatica'?
What is union transformation?
What is mapplet in informatica?
What is the use of code page?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
Define sessions in informatica etl?
What is union transformation in informatica?
