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 |
How can we integrate different flat file data in a single mapping and with in a single execution
when we use lookup,if have 5 records,if i dont need 1st and 2nd records..what will be the procedure to achieve by using lookup?/
Could you explain what is enterprise data warehouse?
HOE DO U IMPLIMENT SCHEDULING IN INFORMATICA?
In informatica workflow manager, how many repositories can be created?
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
Can we write to_date(three arguments) ? Will it work ? Advance thanks
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
What are the different versions of informatica?
What are the tasks that source qualifier performs?
how to get the first row without using rank t/r?
If we use sorted ports in aggregator transformation and somehow records are not in order by format so what will happen,session fails or it succeeded with incorrect data?