CAN ANY ONE SEND ME THE CODE FOR THE BELOW
1).REMOVE '_' FROM TELE PHONE "323-237-2323" AND SHOULD
DISPLAY OUT PUT AS "323237232"
2). NEED TO ONLY "COMPANY.COM" FROM EMAIL
FILED "TEST@COMPANY.COM"
- 11 Answers
- 14368 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / kumar
Use trim(columnname,'_','a') to remove the '-' values from
the columns
2) use field function: field(columnname,'@'2) to get the
company.com
Thanks
Kumar
| Is This Answer Correct ? | 2 Yes | 7 No |
Can u access a repository created in previous version of Informatica?
What is tracing level? How many types of transformations supported by sorted input?
where are the log files generally stored.Can you change the path of the file.what can the path be?
Compare etl & elt?
Can anyone please send me the latest informatica dumps (power center 8.1.1) for all the three exams? My mail id is yokilamai@gmail.com
What are snapshots? What are materialized views & where do we use them? What is a materialized view log?
What is staging area referring to?
How can write SQL Overwrite to get Daynamic rows from the source in SQ transformation!(Any Example)
In the SEQ generator which property has to be set to generate seq No. when the input data is more than the max limit.
what is SMP AND MPP?
what is the difference between cardinality and Nullability?
what is session partitioning?
Teradata 
