What is regex (lookup)? When you should use it?
Answer Posted / 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 |
Post New Answer View All Answers
Explain the ab initio etl tool in high level?
What is m_dump?
Explain PDL with an example?
Do you know what a local lookup is?
List out the file extensions used in abinitio?
What would be the next step after collecting the data?
What is data encoding?
What is the role of co-operating system in abinitio?
How is the partitioning with key different from round robin partition?
Input A 100 NUll A NUll 200 B 100 Null B Null 300 Output A 100 200 B 100 300 Do this using Ab initio
Why might the optimizer use a table scan when an index is available?
What is a cursor? Within a cursor, how would you update fields on the row just fetched?
What is the purpose of having stored procedures in a data-based?
What is the return type of lookup_not_loaded() ? Does it return 0 or 1 to signify true or false or does it return index ...can someone please explain.
I am unable to connect sever database(oracle) from gde(db config file) local system.i set all these?