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 can we update a record in the target table without using update strategy?
Can we create a Integration service without a Repository service and vice versa?
Explain direct and indirect flat file loading (source file type) - informatica
As union transformation gives UNION ALL output, how you will get the UNION output?
update strategy transformation in informatica
Design time, run time. If you don't create parameter what will happen
What are the features of complex mapping?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
tell me 5 session failure in real time how can you solve that in your project?
How might one distinguish in the case of mapping is right or not without associating session?
Have you worked with/created Parameter file
Can we create two repositories on same database instance in oracle?
explain abt ur project architecture?
State the differences between sql override and lookup override?
Mention some types of transformation?