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
- 16854 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What do you understand by active and passive transformations?
Explain about the data integration suite features?
where we cannot use sorter Transformation. if we use then we will not get correct data?
State the differences between shortcut and reusable transformation
A mapping contains source table S_Time(stat_year,end_year) target table TIM_DIM(date,day,month,year,quarter) stored procedure transformation: A procedure has two parameters I_end_year and output parameter as O_date ,day , month, year, quarter, If this session is running, how many rows will be available in the target and why?
How can you use an Oracle sequences in Informatica ? You have an Informatica sequence generator transformation also. which one is better to use?
What is meant by incremental load?
Can we create Hierarchies in generic datasources?
what is session partitioning?
Give a way in which u can implement a real time scenario where data in a table is changing and u need to look up data from it.How will u configure the look up transform for this purpose?
What are snapshots? What are materialized views & where do we use them? What is a materialized view log?
What are the types of data warehouse applications and what is the difference between data mining and data warehousing?
what is a worklet?
What are dimensions?
Explain and compare etl & manual development?
