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
- 13422 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 the procedure for creating independent data marts from informatica 7.1?
How do you convert single row from source into three rows into target?
What does role playing dimension mean?
Explain informatica architecture - version 8 / 9
how we can load rejected record's at run time?(not through bad files)
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
What is the sequence generator transformation in informatica?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
difference between informatica 8.1.1 and 8.6
How to update source definition?
can we override a native sql query within informatica? Where do we do it? How do we do it?
Is it possible to define a single node as a Gateway node as well as worker node?
What are the new features of informatica 9.x in developer level?
What is a repository manager?
