Interested to Buy Any Domain ? << Click Here >> for more details...
What is regex (lookup)? When you should use it?
- 3 Answers
- 15725 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 are the Types of parallelism in detail?
How data is processed and what are the fundamentals of this approach?
What will be the output when a file with 0 records is connected as input to a reformat and an output file? Note that in reformat we have assigned hardcoded values to output columns.
how to prepare scd2 in abinitio
List out the file extensions used in abinitio?
what is macro?At what situation we have to face?
State the working process of decimal_strip function?
Can you use scan to generate sequence number ? How to use in abinitio graph?
What are the steps to create a repository in ab initio?
What information does a .dbc file extension provides to connect to the database?
What is regex (lookup)? When you should use it? How to use in abinitio graph?
What is the ab initio business rules environment (bre)?
Teradata 
