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
Describe how you would ensure that database object definitions (tables, indices, constraints, triggers, users, logins, connection options, and server options etc)are consistent and repeatable between multiple database instances (i.e.: A test and production copy of a database)?
What are the different types of parallelism in ab initio?
When we should use 'jobid' for commit table (Output table component??
What is ab initio enterprise meta>environment (eme)?
Explain what is the architecture of abinitio?
State the working process of decimal_strip function?
How can you SORT an already partitioned (round-robin) data ? How to use in abinitio graph? 3. How internally partition by key decides which key to send in which partition ? How to use in abinitio graph? 4. What is PDL ? Give him a shell type parameter and ask him to convert it to PDL. How to use in abinitio graph? 5. As shell type parameters are not supported by EME, then how you can use shell type parameter (If you don't want to use PDL) without hampering lineage diagram ? How to use in abinitio graph? 6.How you can generate dml from a COBOL copy book ? How to use in abinitio graph? 7. How you can convert from ebcdic to packed decimal ? How to use in abinitio graph?
What is the purpose of having stored procedures in a data-based?
What are the different types of parallelism used in abinitio?
Can anyone give me an example of realtime start script in the graph?
Input - Name|city |startyear Rahul |Mumbai|2010 Rahul|kolkata|2014 Rahul|Delhi|2018 Output should be- Name|city |startyear|endyear Rahul |Mumbai|2010|2014 Rahul|kolkata|2014|2018 Rahul|Delhi|2018|9999
When we should use 'jobid' for commit table (Output table component?? How to use in abinitio graph?
What are the various types of layout supported by abinitio?
What do you understand by local lookup?
What are the different types of partition components in abinitio?