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
What is a partition?
Why might the optimizer use a table scan when an index is available?
What will be the skew for, input file->partition by key-> partition by round robin->output file
Have you used the rollup component? Describe how?
Tell us about the architecture of abinitio.
How do you add default rules in transformer?
What is abinitio?
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)?
i have a scenario where i need to change the value of a sort order in my sort component whether ascending or descending depend on some input value... e.g if input_val = A then sort order should be ascending else descending I have to use PDL in this... Can you please tell me where do i have to make this change and how ?
Explain what does dependency analysis mean in abinitio?
Describe the evaluation of parameters order in ab initio?
What are the fundamental blocks of co> operating system of ab initio?
What do you understand by overflow errors?
Describe the grant/revoke ddl facility and how it is implemented?
What are the different types of parallelism in ab initio?