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
How to load data in informatica ?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
What is rank transform?
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
expain about the tune parameters?
What is mapplet in informatica?
What are the different versions of informatica?
How big was your fact table
How do you load only null records into target?
What is meant by a domain?
whats the logic to load the lower level of granularity of data to fact table.
difference between informatica 8.1.1 and 8.6
What is the status code in stored procedure transformation?
How do you migrate data from one environment to another?
tell me 5 session failure in real time how can you solve that in your project?