Tag: technology

Questions Related to technology

Which orchestrate operator is inserted at compile time when RCP is enabled
technology

  1. Import operator

  2. APT combined controller

  3. Modify operator

  4. None of the above

Show answer
Correct Option: B

Why Lookup File set must need a Key column?
technology

  1. Remove Duplicates

  2. Memory Limit

  3. Reference to a Lookup

  4. None of above

Show answer
Correct Option: A

How will you take rejects from Transformer stage?

technology

  1. Using Otherwise log

  2. Using Constraints

  3. Using functions

  4. All the above

Show answer
Correct Option: A

What are the operations performed in modify stage?
technology

  1. Null handling

  2. Type conversion

  3. Dropping a particular column

  4. All the above

Show answer
Correct Option: D

How datastage makes decision on which configuration file to use
technology

  1. By using State file

  2. By using administration setting in DS admin

  3. By using the path in datastage director

  4. By using APT_CONFIG_FILE environment variable

Show answer
Correct Option: D

The Number of reject link(s) in Merge Stage is based on?
technology

  1. Primary Link

  2. Update Link

  3. Number of Records

  4. All the above

Show answer
Correct Option: B

If the pivot includes any derivations with fewer than the maximum number of output rows but more than one row, the output row contains
technology

  1. Null value for each column

  2. Null value for each column where a derivation is not available

  3. Null value for each column where a derivation is available

  4. None of the above

Show answer
Correct Option: D

Which of the below statements is true about configuration file

technology

  1. Datastage gets the shape and size of system from configuration file and organizes according to it

  2. once system is upgrade or improved, no need to change the jobs

  3. Jobs can be developed on one platform and implemented in other platform

  4. All the above

  5. None of the above

Show answer
Correct Option: D

How to override default settings of environmental variables through datastage client
technology

  1. Datastage Administrator

  2. Datastage Designer

  3. Datastage Director

  4. All of the above

Show answer
Correct Option: D

In Datstage server, what are the benefits of using hashed files?
technology

  1. Hashed files are the best way to store data for lookups.

  2. Hashed files are especially useful if they store information with data dictionaries (customer details, countries, exchange rates).

  3. Very fast when looking up the key-value pairs.

  4. All the Above

Show answer
Correct Option: D