Interested to Buy Any Domain ? << Click Here >> for more details...
in my source table one of column contains the data like
vishnraju@gmail.com,suresh@yahoo.com,krishna@hotmail.com these
records i need to send in target table as below format.
vishnuraju,suresh,krishna
- 5 Answers
- 12997 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / rayudu
HI ,
By using substr and instr we can retrive only the name part from the entire string and send to target.
Regrds,
rayudu
| Is This Answer Correct ? | 8 Yes | 2 No |
Post New Answer View All Answers
What is meant by LDAP users?
What are the designer tools for creating transformations?
What are the reusable transformations?
Enlist few areas or real-time situations where informatica is required.
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
What is the need of an ETL tool?
Explain Dataware house architecture .how data flow from intial to end?
How to implement security measures using repository manager?
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
What is the difference between informatica 7.0 and 8.0?
Mention few power centre client applications with their basic purpose?
In development project what is the process to follow for an etl developer from day1
How to load last n records of file into target table - informatica
What are the performance considerations when working with aggregator transformation?
without table how to come first record only in oracle?
