. How can you get all the fields form a lookup files ?
(Which function)
- 3 Answers
- 10186 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 difference between .dbc and .cfg file?
What are Cartesian joins?
What is .abinitiorc and What it contain?
How we can remove temp files of a failed job if .rec is not available ? How to use in abinitio graph?
What is the return type of lookup_not_loaded() ? Does it return 0 or 1 to signify true or false or does it return index ...can someone please explain.
How you can test a dbc file ?
How many parallelisms are in Abinitio?
We have file having country_name customer_name.For exp London Ram Bangalore Rohit London Shyam Bangalore Abhinav In output we need 2 files one file for london and second file for Bangalore.How to acheve this?
What is AB_LOCAL expression where do you use it in ab- initio?
Can you run air sandbox run using pset ?
How co>operating system integrates with legacy codes?
can any one help me now i am learning AB Inito but i don't have material and pdf's can any one provide pdf's to this mail id mohanraju0113@gmail.com thanks in advance...................................
Teradata 
