Tag: technology

Questions Related to technology

What is (are) the difference between Lookup, Join and Merge

  1. Memory usage

  2. Sorting

  3. Treatment of rows with unmatched keys

  4. All the above


Correct Option: D
  1. Data Stage Engine, Meta Data Repository, Package Installer

  2. Data Stage Administrator, Data Stage Designer, Data Stage Director

  3. Data Stage Engine and Meta Data Repository

  4. Data Stage Engine and Package Installer


Correct Option: A
  1. enabled in DataStage Administrator

  2. attached to a table definition in DataStage Manager

  3. enabled at the stage level

  4. enabled with environmental parameters set at runtime


Correct Option: A,C
  1. ExecCommand Activity stage

  2. UserVariables Activity stage

  3. Sequencer Activity stage

  4. Routine Activity stage

  5. Nested Condition Activity stage


Correct Option: A,B,D
  1. The lookup stages use more memory than the Merge and join stages.

  2. The source primary input link must be sorted.

  3. Both

  4. None of the above


Correct Option: A

Which of the following is valid about shared containers?

  1. These are reusable job elements.

  2. They can only be used within a project

  3. When shared containers are modified. Modifications are reflected in all the jobs that use them.

  4. None of the above


Correct Option: C

AI Explanation

To answer this question, let's go through each option to understand why it is correct or incorrect:

Option A) These are reusable job elements - This option is incorrect. Shared containers are not necessarily job elements. They can be used to share common resources or configurations across multiple jobs or projects.

Option B) They can only be used within a project - This option is incorrect. Shared containers can be used across multiple projects, not limited to a single project.

Option C) When shared containers are modified, modifications are reflected in all the jobs that use them - This option is correct. Shared containers allow for centralizing configurations or resources that are common to multiple jobs. When a shared container is modified, these modifications are reflected in all the jobs that use the shared container, ensuring consistency across jobs.

Option D) None of the above - This option is incorrect since option C is valid about shared containers.

The correct answer is C. This option is correct because shared containers allow for modifications to be reflected in all the jobs that use them.

  1. Combinability mode

  2. Preserve partitioning

  3. Execution Mode

  4. Don’t combine mode


Correct Option: B

Which records are taken in the reject link in Transformer stage?

  1. Condition not met

  2. Mismatched Meta data

  3. Null records

  4. None of the above


Correct Option: A

Which options allow you to specify a string at the end each record?

  1. Record delimiter string

  2. Field delimiter string

  3. Record Prefix

  4. Final delimiter


Correct Option: A