. How can you get all the fields form a lookup files ?
(Which function)
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 ab_work_dir and .work
What do you mean by the term data warehousing? Is it different from data mining?
How we can remove temp files of a failed job if .rec is not available ? How to use in abinitio graph?
Mention some file extensions which are used in abinitio?
Mention what information does a .dbc file extension provides to connect to the database?
When running a stored procedure definition script how would you guarantee the definition could be rolled back in the event of problems?
what is decoding & what is NVL?
How to replace last 4 digits of an input column with XXXX given input column has 12 digits?
What are the co> operating system’s assorted library of integrated components?
In Join component which record will go to unused port and which will go to reject port ?
what is deeup in unique only?
How you can create cross joined output using join component ?