Interested to Buy Any Domain ? << Click Here >> for more details...
What is regex (lookup)? When you should use it?
- 3 Answers
- 15681 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 |
How to connect mainframe to Abinitio?
Do you know what a local lookup is?
How we can remove temp files of a failed job if .rec is not available ? How to use in abinitio graph?
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 ?
I wanted to learn Ab Initio, Could you please send the material to my personal email id.
What is the difference between In-Memory Sort and Inputs must be sorted?
How we khow a database is connected in Abinitio?
What are the steps to create a repository in ab initio?
What is the default layout of a component ? Is it mandatory to set the layout of a component ?
EmpId RollNo RollNo2 A t1 se A1 se tm i want output as A Emp A TL A1 SE etc how i can get output please send me your answer
What is a look-up?
what is decoding & what is NVL?
Teradata 
