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
- 7364 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
What is the need for an etl tool?
Write the unconnected lookup syntax?
According to his methodology what all you need before you build a datawarehouse
What are the types of caches in lookup?
How do you set a varible in incremental aggregation
Can informatica load heterogeneous targets from heterogeneous sources?
Explain target update override in informatica
What does reusable transformation mean?
What is a joiner transformation?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
Write the advantages of partitioning a session?
What are the different types of olap? Give an example?
What is enterprise data warehousing?
How to configure mapping in informatica?
Differentiate between Load Manager and DTM?
