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
- 7303 Views
- I also Faced
- E-Mail Answers
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
What is meant by active and passive transformation?
where to store informatica rejected data? How to extract the informatica rejected data?
What is dynamic cache?
What is expression transformation?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
how tokens will generate?
What is different between the data warehouse and data mart?
design of staging area?
Explain what are the different types of transformation available in informatica.
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
What are the prerequisite tasks to achieve the session partition?
Enlist the differences between database and data warehouse.
Separate from a database, an information bazaar, and an information stockroom?
Design a mapping to load a target table with the following values from the above source?
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 ?
