Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 16867 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 |
how to join two tables without using joiner transformation .advantages of joiner over lookup and vice versa.
Eliminating of duplicate records without using dynamic lookups
can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.
What is granularity? Please explain with example
explain the methodology of Data Warehousing?(Polaries)
list the transformation used for the following:Heterogeneous sources,Homogeneous sources,Find the 5 highest paid employees with in a dept,create a summery table,generate surrogate keys
how to load the data to fact table?
can u anyone plz share some etl testing interview question . and share the sql queries and unix . plz help me to clear in the etl testing interview by sharing ur knowledge
Just Completed the informatica Certification ,for Dumps please email me on infamaddy@gmail.com i will send it to you
how do u set the size of block buffer?
what are the facilities provided by OLAP to analytical users?
What is grain of fact?
Teradata 
