Interested to Buy Any Domain ? << Click Here >> for more details...
How will restrict values in 0-9 and A-Z and a-z and special
character.Only allowed these chars otherwise we will reject
the records? what is the function we used to restrict...
- 3 Answers
- 9010 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / abhishek
REGEXP_LIKE(COL_NAME,'[[:alphanum:]]')
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain direct and indirect flat file loading (source file type) - informatica
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.
What are the performance considerations when working with aggregator transformation?
Did u used latest transformations of 8.6.0? for what?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
Explain about cumulative Sum or moving sum?
What does role playing dimension mean?
What are different types of transformations available in informatica?
what is size of u r database?
what is the hint? how to use it to reduce the query processing in program?
I have a flat file, want to reverse the contents of the flat file
Explain target update override in informatica
What are the different types of transformation available in informatica.
Differentiate between a repository server and a powerhouse?
