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
- 7123 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / sivaramakrishna
boss am not getting i have tried as u said
thank you
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / 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 |
Answer / bhagwati
reverse function will return the character string after reversing it.
For e.g. reverse(Aman_Gupta) will return atpuG_namA
| Is This Answer Correct ? | 0 Yes | 0 No |
Can you try reverse function in informatica....
| Is This Answer Correct ? | 0 Yes | 1 No |
what is flat file override?
i have source in oracle 10g,oracle 8i how will u take the data from two sources
Hi,tell me the system testing and Integration Testing in the Informatica ? Thank You
What is Test load plan? Let us assume 10 records in source, how many rows will be loaded into target?
how to declare array in plsql?
Can we use different lookup tranformations for a same lookup table (lookup condition may or may not be same)with different output ports? How the cache files will be affected? Please clarify..
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
Is there any model difference between ODS and DWH
In Datastage, we have row generator stage to generate dummy row. Is there any such transformation in Informatica. Thanks in advance, Kumar
How will you display "Mr" for male & "Mrs" for female in target table?
What are the main issues while working with flat files as source and as targets ?
How to generate sequence numbers using expression transformation?
Teradata 
