Interested to Buy Any Domain ? << Click Here >> for more details...
What is regex (lookup)? When you should use it?
- 3 Answers
- 15529 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 can you count the total no .of records in the specified partition in the Multifile?
How to add default rules in transformer?
How co> operating system natively processes the data?
Mention some file extensions which are used in abinitio?
Mention what are the different types of parallelism used in abinitio?
Have you used the rollup component? Describe how?
Broadcast and replicate does the similar work , what’s the diff then
What is local and formal parameter?
What is the use of the co> operating system in ab initio?
How to insert/update a csv file by comparing it with another csv file? for example, i have 2 input files : ColA ColB ColC 1 A AA 2 B AB 3 C CC and second one : ColA ColB ColC 2 B BB 4 D DC Job should compare these 2 files and update the records present in first input file. so the output file will look like this: ColA ColB ColC 1 A AA 2 B BB 3 C CC 4 D DC
hi, am put into Ab initio now. I need some material for to learn it!! i have to give a test also.. can anyone help me provide material please....
i need help from u. i want to learn abinitio. please provide pdfs or material or books.
Teradata 
