. How can you get all the fields form a lookup files ?
(Which function)
- 3 Answers
- 11113 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 |
How do you add default rules in the transformer?
How transaction file different from that of a sort file?
In MFS i developer developed 2-way, but supporters r supporting 4-way on same records how is possible?
What is sort component in abinitio?
What is the difference between check point and phase?
What is local and formal parameter?
What is air_project_parameters and air_sandbox_overrides? what is the relation between them?
How to implement the funtionality in the custom component to use in the graph?
Can you read multiple input files using one input file component ? (Same DML) How to use in abinitio graph?
How do you convert 4-way mfs to 8-way mfs?
what is the use of catlog or catlogfile?
what is the relation between EME , GDE and Co-operating system ?
Teradata 
