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 |
what is the hint? how to use it to reduce the query processing in program?
hi guys..iam a QA person ..what is ETL TESTING... what is the process of ETL testing... ETLTESTER needs etl devolopment knowledge or not? pls suggest ur valuable decision
Can you copy the session to a different folder or repository?
what are the difference between Informatica 7.1 and 8.1?
what are objects in data warehouse?
how you will maintain version?
Any one tell me some 5 session failure in real time?And why problem occur how to solve the issues?
What is the difference between OLTP and ODS?
Diff b/w ShortCut and reusabel Object ?
Why do flat file load is faster if you compare that with table load ? Please answer me. Advance Thanks, Manojkumar
On a day, I load 10 rows in my target and on next day if I get 10 more rows to be added to my target out of which 5 are updated rows how can I send them to target? How can I insert and update the record?
i have to extract data from a flat file.the flat file has 10 records.i have to extract the 1st and 5th record every time.how is it done.