split two strings into two columns
For Eg.
Source:-Full Name: Shiva Kumar
Target:-
First Name:Shiva
Last Name:Kumar
- 1 Answers
- 15859 Views
- Cap Gemini, TCS, Wipro, I also Faced
- E-Mail Answers
Answer / 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 |
How identifying bottlenecks in various components of informatica and resolving them?
Is it possible to use a client with different version than that of its Informatica server?
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
Explain about Informatica server process that how it works relates to mapping variables?
what are the transformations that restricts the partitioning of sessions?
From where you extract the data, how you did it into informatica? explain....
1 Answers Accenture, Unisoft Infotech,
What are mapplets?
1 2 3 * 4 5 6 * 7 8 9 how to load records between two stars(*),
What is factless fact schema?
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
Why union transformation is an active transformation?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
Teradata 
