What is regex (lookup)? When you should use it?
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 are the co> operating system’s assorted library of integrated components?
name the air commands in ab initio?
What is common among data validity and data integrity?
How can you achieve scan using reformat ?
. How we can remove temp files of a failed job if .rec is not available
What is the difference between dml expression and xfr expression?
What are the functions of the replicate and dedup component?
Pdl with an example?
What is the role of co-operating system in abinitio?
Explain the methods to improve performance of a graph?
Mention what is the syntax for m_dump in abinitio?
Layout - L1*, L1 - What is the difference