Tag: technology

Quizzes (307) Questions (36705)

Questions Related to technology

Multiple choice technology

How an output file can be used as a lookup file?

  1. In the same graph, use the URL and record format of the output file in a Lookup file dataset component.

  2. In the same graph, by checking the "Add to Catalog" option in the Output file and specifying the key.

  3. By simply using the Output File Name (without specifying anything additionally) in any lookup function and access its values.

  4. All of the above
Reveal answer Fill a bubble to check yourself
B Correct answer
Full explanation
Multiple choice technology

Where we can use local lookup Function?

  1. In case of serial lookup files where lookup file is created in the same graph.

  2. In case of serial lookup files, being accesed from a component running in parallel layout.

  3. In multi-file lookup, local to a particular partition depending on the lookup key

  4. None of the above
Reveal answer Fill a bubble to check yourself
C Correct answer
Full explanation
Multiple choice technology

Identify the False statement among the following :

  1. One can use Interval, Interval_top, Interval_bottom etc. modifiers in the key specifier of a Lookup file to search within a range.

  2. A common use of Lookup files is to process data records of multiple files if one of them is small enough to fit in memory, as a substitute of using Join component.

  3. Suppose we use a lookup expression as :- lookup("CUST_NAME_LKP", "Jack").cust_id -- Now if there are multiple records in the lookup file against the name "Jack", only the first matching cust_id value is returned.

  4. When we use a file as Lookup, the entire file is read into memory and accessed as a hash table.
Reveal answer Fill a bubble to check yourself
C Correct answer
Full explanation