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
How to run a graph infinitely?
Mention what is a partition and what are the different types of partition components in abinitio?
What is a local lookup?
What is the difference between a scan component and a rollup component?
Difference between informatica vs ab initio?
Do you know what a local lookup is?
How co> operating system natively processes the data?
How can we increase the loading performance of oracle table in AbInitio?
Explain what is sort component in abinitio?
Have you used rollup component? Describe how.
Given input file with single column having 1 2 2 4 3 .. Required output 1 2 2 4 4 4 4 3 3 3.. How?
How to find the project(pub,priv,common,client) in between public, Private,common?Any identification?
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?
Explain how you can run a graph infinitely in ab initio?
Why might you create a stored procedure with the with recompile option?