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
- 13599 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 |
Mention few test cases and explain them?
how do u really know that paging to disk is happening while u are using a lookup transform?
how to join two tables without using joiner transformation .advantages of joiner over lookup and vice versa.
How many steps etl contains?
what is pmrep command?
hoe to access second value in mapping parameter if it is having more than one value ?????????????
When do we use dynamic cache and static cache in connected and unconnected lookup transformations? Difference between stop and abort
how many steps are there in etl process?
what is dynamic insert?
how do u estimate the depth of the session scheduling queue? Where do u set the number of maximum concurrent sessions that Informatica can run at a given time?
what is session partitioning?
How many steps etl contains explain with example?
Teradata 
