Interested to Buy Any Domain ? << Click Here >> for more details...
split two strings into two columns
For Eg.
Source:-Full Name: Shiva Kumar
Target:-
First Name:Shiva
Last Name:Kumar
- 1 Answers
- 15642 Views
- Cap Gemini, TCS, Wipro, I also Faced
- E-Mail Answers
Answer Posted / venky
output1=substr(name,1,instr(name,' ')-1)
output2=substr(name,instr(name,' ')+1)
output1 means firstname
output2 means last name
| Is This Answer Correct ? | 26 Yes | 1 No |
Post New Answer View All Answers
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
Which transformation is needed while using the Cobol sources as source definitions?
Why filter transformation is an active one?
tell me about your project functionality
What is Data Caches size?
What is session task and command task?
How do you take back up of repository?
Explain the pipeline partition with real time example?
What is a node in Informatica?
How to extract sap data using informatica?
What are the different types of transformation available in informatica.
What are the different versions of informatica?
How many number of sessions can one group in batches?
What is the cumulative sum and moving sum?
How do you load only null records into target?
