What is regex (lookup)? When you should use it?

Answers were Sorted based on User's Feedback



What is regex (lookup)? When you should use it?..

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

What is regex (lookup)? When you should use it?..

Answer / prakash balakrishnan

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

What is regex (lookup)? When you should use it?..

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

Post New Answer

More Ab Initio Interview Questions

Have you used rollup component? Describe how.

0 Answers  


What is regex (lookup)? When you should use it? How to use in abinitio graph?

1 Answers   Steria, Wipro,


what is the syntax of m_dump command?

3 Answers  


Mention what is a partition and what are the different types of partition components in abinitio?

0 Answers  


. How can you run a graph continuously without using continuous components ?

3 Answers   TCL,






Broadcast and replicate does the similar work , what’s the diff then

4 Answers   TCL, Wipro,


We know rollup component in abinitio is used to summarize a group of data record then why do we use aggregation?

0 Answers  


What is the language used in Ab Initio ?

4 Answers  


) How can you count the total no .of records in the specified partition in the Multifile?

5 Answers  


Graph was failed how it is achived ? send answer with phone number? i want speak with directly who is intrest on abinitio?

1 Answers   HCL,


What are the factors on which storage of data depends?

0 Answers  


How can we increase the loading performance of oracle table in AbInitio?

0 Answers  


Categories