. How can you get all the fields form a lookup files ?
(Which function)
- 3 Answers
- 11051 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 |
Explain how you can run a graph infinitely in ab initio?
What are differences between different gde versions(1.10,1.11,1.12,1.13and 1.15)?
Difference between public and private projects and how to make private to public?
What is the purpose of having stored procedures in a data-based?
What is de-partition in abinitio?
Input - Name|city |startyear Rahul |Mumbai|2010 Rahul|kolkata|2014 Rahul|Delhi|2018 Output should be- Name|city |startyear|endyear Rahul |Mumbai|2010|2014 Rahul|kolkata|2014|2018 Rahul|Delhi|2018|9999
What are the types of data processing you are familiar with?
i have a scenario where i need to change the value of a sort order in my sort component whether ascending or descending depend on some input value... e.g if input_val = A then sort order should be ascending else descending I have to use PDL in this... Can you please tell me where do i have to make this change and how ?
I have $AI-SERIAL/DML------> (SERIAL FILE LOCATION) AND $BDS-SERIAL/DML---------->(what is the location what is mean)?
How to create a repository in abinitio for stand-alone system(local nt)?
What do you know about abinitio?
How can you export a component’s internal parameters ?
Teradata 
