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
- 6919 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 |
Hi Every One When i Start the Workflow, Table is Going to be Stored in the target database But the columns are not going to the target database table in my PC , please give me the solution and waiting for solution
What is parallel processing in informatica?
What are the advantages of informatica?
What are the different types of repositories created using informatica?
how do u tune queries?
In a scenario I have col1, col2, col3, under that 1,x,y, and 2,a,b and I want in this form col1, col2 and 1,x and 1,y and 2,a and 2,b, what is the procedure?
empno sal 1 8000 2 9000 3 8000 4 1000 how to get highest sal wise rankings in rank t/r.
Explain the different kinds of facts.
hi,there is a scenario like. there are three columns empid,salmonth, sal contains the values 101,jan,1000 101 feb 1000 like twelve rows are there then my required out put is like contains 13 columns empid jan feb marc.......dec and the velues are 101 1000 1000 1000 like this . thank you
Which means the first record should come as last record and last record should come as first record and load into the target file?
Plz can anybody send Informatica and Cognos FAQ Plz To thid ID ppradeep_dwh@ayhoo.co.in
What if i will group by with some port in aggregator and will not pass the sorted values. Will the session fails tell in both cases ( if i have configured it for sorted input and if i have not configured it for sorted input).
Teradata 
