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 / shankarmba07@gmail.coom
In eXP transformation create 3 ports like:
name1:select substr(name,1,instr(name,'_',1,1)-1)
name2:select substr(name,instr(name,'_',1,1)+1)
O_Name:name2||'_'||name1)
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How can repository reports be accessed without sql or other transformations?
What is the difference between informatics 7x and 8x and what is latest version?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
draw informatica architecture 8.6 ?
Is it possible to define a single node as a Gateway node as well as worker node?
How to partition the Session?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
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
What are the reusable transformations?
How to generate sequence numbers using expression transformation?
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
What will be the approach?
What is rank transform?
Please let me know how to make Data masking in informatica..
what is the size ur source like(file system or database)? how many record daily come u r banking project?