Interested to Buy Any Domain ? << Click Here >> for more details...
What is regex (lookup)? When you should use it?
- 3 Answers
- 15688 Views
- HCL, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / rajat singh
In a regex lookup operation, each record in the lookup file must contain a regular expression in the format described in “Regular expressions in DML functions”. The regex key specifier of a regex lookup file identifies the record field to interpret as a regular expression.
A lookup function such as lookup (file_label , expression) tests the value of its second argument against the regular expression field in each record of the lookup file, until the function finds a match.
| Is This Answer Correct ? | 3 Yes | 0 No |
In INTERVAL LOOKUP we will be defining certain range of
values like 0 - 10 , 10 - 20. Similarly in regrex lookup we
will be defining values like 0|1|2|3
| Is This Answer Correct ? | 1 Yes | 2 No |
Answer / ramakrishna
lookup is also similar to join.. by using the following
syntax we will fetch the info from lookup
lookp("looupfilename",conidition).field want to fecth from
lookup
| Is This Answer Correct ? | 1 Yes | 8 No |
. What is flow buffering ? How it reduces the chances of having deadlock ?
How to find the project(pub,priv,common,client) in between public, Private,common?Any identification?
Explain the methods to improve the performance of a graph?
How to add default rules in transformer?
what is the output when -1 is put in select_expr of FBE?
What are the facts that can compromise data integrity?
How transaction file different from that of a sort file?
Describe the elements you would review to ensure multiple scheduled batch jobs do not collide with each other?
What is de-partition in abinitio?
Explain what is the architecture of abinitio?
How to get DML using Utilities in UNIX?
What do you mean by the overflow errors?
Teradata 
