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
- 6978 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
What is source qualifier transformation in informatica?
What are the data movement modes in informatica?
Where do we use mapping variables in informatica?
Enlist the various types of transformations.
How many numbers of sessions can one group in batches?
Explain pushdown optimization $pushdownconfig parameter - informatica
What are Dimensional table?
What is the status code in stored procedure transformation?
define galaxy repository in informatica
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
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.
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
permutations of mapplet
