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
- 9339 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 |
have you developed documents in your project? and what documents we develop in realtime?
Hi Experts , Can you please help me regarding the below question How to remove first three rows and last three rows in informatica.. thanks and regards Natraj
WAT IS TEXT LOAD?
What is the expected value if the column in an aggregator transform is neither a group by nor an aggregate expression?
What is the difference between writing a joiner query in ANSI style and THETA style?
What is deployemnt groups, Lables, query and dynamic deployment group.
one source to target loading insert new rows and update existing rows?
wt is the difference between truncate and delete in which situation u use delete and truncate in real time..
After a load is done to my target table, I need to insert a last row, which might be formed at some expression transformation and brought to target. Do I have to have separate mapping to be run after the 1st mapping? Or in a single mapping how to achieve this?
hw to load this give the mapping? cty state o/p c1 s1 c1 c1 s2 s1 c1 s1 c1 c2 s3 s2 c3 s4 c1 c3 s2 s1 c2 s3 c3 s4 c3 s2 2 columns should be loaded to one column in target table?
What is informatica?
How will you check the bottle necks in informatica? From where do you start checking?
Teradata 
