Interested to Buy Any Domain ? << Click Here >> for more details...
What is regex (lookup)? When you should use it?
- 3 Answers
- 15485 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 |
What is $mpjret?
What is the use of aggregation when we have rollup as we know rollup component in abinitio is used to summarize a group of data record? Then where we will use aggregation?
What do you know about abinitio?
What are the kinds of layouts does ab initio supports?
What is a ramp limit?
What is AB_LOCAL expression where do you use it in ab- initio?
Can you read multiple input files using one input file component ?(same DML)
Mention what is a partition and what are the different types of partition components in abinitio?
what is the project environment(for each project the environment is same or different to different project)?
How scientific data processing is different from commercial data processing?
What does de-partition mean in abinitio?
What dedup-component and replicate component does?
Teradata 
