MY SOURCE IS LIKE THIS VENKATESH,101||RAJESH,102||SIVA,103||SWATHI,104
MY REQUIRMENT IS
NAME ID
VENKATESH 101
RAJESH 102
SIVA 103
SWATHI 104
PLEASE PROVIDE ME THE SOLUTION
Answer Posted / saket
Separate VENKATESH ,101
Rajesh,102
Siva ,103 by using "||" as delimiter .
Then in the expression Divide the string Venkatesh ,101 intto two separate variable using string operation and output that two separate columns of the target
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Explain the different dimensions.
How identifying bottlenecks in various components of informatica and resolving them?
Describe an informatica powercenter?
What's the layout of parameter file (what does a parameter file contain?)?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
What does command task mean?
Can informatica load heterogeneous targets from heterogeneous sources?
Enterprise data warehouse your projects phase by phase explain?
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
Write the different tools in the workflow manager?
What are the transformations that are not supported in mapplet?
How are the sources and targets definitions imported in informatica designer?
what is diff b/t sorter t/r and agg have the option sorter property...
Why do you use Mapping Parameter and mapping variable?