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 / vijaya
two types
treat consecutive delimiters as one in import from flat file
then use a normalizer transformation you will get the answer
second type in unix scripting you can get the o/p
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What is the difference between writing a joiner query in ANSI style and THETA style?
what is degenerated dimension?
Scheduling properties,whats the default (sequential)
What are the new features of informatica 9.x at the developer level?
What is Session and Batches?
In how many ways we can create ports?
What is the status code in stored procedure transformation?
Different circumstance which drives informatica server to expel records?
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
What are the types of caches in lookup?
What is a filter transformation?
How do you update the records with or without using update strategy?
What are mapplets?
Define sessions in informatica etl?
What are the performance considerations when working with aggregator transformation?