. How can you get all the fields form a lookup files ?
(Which function)
- 3 Answers
- 10583 Views
- TCL, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / pritam
This can be done using lookup() function where we can give
the lookup component name and the keys and it will give the
entire record as output..
lookup("look up file",key)
| Is This Answer Correct ? | 4 Yes | 1 No |
Answer / keerthika
We can use like
out.field1 :: lookup("LOOKUP_FILE_NAME".Key).Field1_to_be_fetched;
out.field2 :: lookup("LOOKUP_FILE_NAME".Key).Field2_to_be_fetched;
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / sarang ambikar
We can use local variable in a transform to return multiple
field values from Lookup
| Is This Answer Correct ? | 0 Yes | 0 No |
what is the use of catlog or catlogfile?
How to Improve Performance of graphs in Ab initio?
How will u remove header record? How will u remove tailer record?
How you can delete an object from EME data store ? How to use in abinitio graph?
What is a deadlock and how it occurs?
What is a cursor? Within a cursor, how would you update fields on the row just fetched?
What is air-project parameter ? How to use in abinitio graph?
3 Answers IBM, TCL, Tech Mahindra,
Why creation of temporary files depends on the value of MAX CORE
Describe the Evaluation of Parameters order.
What is is a data flow graph?
What are Cartesian joins?
What is regex (lookup)? When you should use it? How to use in abinitio graph?
Teradata 
