Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 4 Answers
- 9334 Views
- I also Faced
- E-Mail Answers
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 |
How do you promote a non-reusable transformation to reusable transformation?
What is the maplet?
what is casual dimension?
where actually the usage of push down optimization happens...
How i can upload the MainFrame source For Informatica ?
What is xml source qualifier transformation in informatica?
how can we use sorter transformation in joins?
What do you understand by term role-playing dimension?
Explain the types of lookup transformation?
tell me about your project functionality
By using joiner t/r we can join only 2 tables, SO if want join more than 2 flat files ,How can i join?
In aggregator transformation, I sort the data before aggregator and select sorted port but still I’m getting an error. What is that error?
Teradata 
