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 / sivaramakrishna

boss am not getting i have tried as u said
thank you

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explian the Process of deployment groups in informatica

657


Differentiate between source qualifier and filter transformation?

998


How to load the data from a flat file into the target where the source flat file name changes daily?

572


What is the sql query overwrite in source qualifier in informatica

617


What is expression transformation?

629






Explain about cumulative Sum or moving sum?

618


Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?

1853


I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?

598


Define joiner transformation?

592


Explain sessions?

604


What is event and what are the tasks related to it?

612


Briefly define a session task?

588


Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?

629


Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM

3448


how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.

1249