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
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / sreekanth
when at the time of this kind of situation we can normally
import the source definitions by treat consecutive
delimiters as one and use the normalizer transformation and
set occurenc
as one and connect those ports to next transformations.
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / 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 |
hai vijaya
will u please explain me in detail
Is This Answer Correct ? | 0 Yes | 0 No |
i having source, router transformation, two targets in my mapping... i given two conditions in router 1)sal >500 2)sal < 5000 --------------- my source is havig two sal records (1)1000 (2)2000 then which target will load first? will both targets are get load or single target only get load...... why?
How to recover the standalone session?
What is event and what are the tasks related to it?
what is the diff b/w cached and unchaed look ups
Is it possible to revert a global repository to local one and why?
what is Active lock explain
Can we change Dynamic to Static or Persistent cache? If so what happens?
What is the Difference between PowerPlay transformer and power play reports?
why normalizer transformation can not used in mapplet? plzzzz answer
What are the mapping parameters and mapping variables?
what is the size of your data warehousing?
daily how much amount of data send to production?