Interested to Buy Any Domain ? << Click Here >> for more details...
I have source like this 1:2;3. so i want to load the target
as 123
- 4 Answers
- 7708 Views
- HP, I also Faced
- E-Mail Answers
Answer Posted / dilip ingole
using sql same thing in informatica also
SELECT REGEXP_REPLACE('1:2;3.','[^[:digit:]]','') DATA FROM DUAL;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to do unit testing in informatica?
How can you differentiate between powercenter and power map?
how we can load rejected record's at run time?(not through bad files)
How big was your fact table
What are mapplets?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
What is meant by lookup transformation?
How many dimensions are there in informatica?
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
What is meant by lookup transformation? Explain the types of lookup transformation?
Why sorter is an active transformation?
What is the difference between informatica 7.0 and 8.0?
lookup transformation with screenshots
What does role playing dimension mean?
Reusable transformation and shortcut differences
