Tag: technology

Questions Related to technology

Using DataStage Director, we __________ a job.
technology

  1. Can compile but can’t run

  2. can run but can’t compile

  3. can compile and run

  4. can’t compile or run

Show answer
Correct Option: B

Which handles the process of scheduling, running and monitoring jobs?

technology

  1. DataStage Administrator

  2. DataStage Director

  3. DataStage Designer

  4. All the Above

Show answer
Correct Option: B

Which is the best partition technique we will use for join stage?
technology

  1. Round robin

  2. Auto

  3. Hash

  4. Entire

Show answer
Correct Option: C

What is the use of Modify stage?
technology

  1. Null_Handling

  2. Datatype conversion

  3. move or keep column

  4. None of the Above

  5. All the Above

Show answer
Correct Option: E

What are types of aggregation you can do it in aggregator?
technology

  1. count,calculation,recalculation

  2. Sort and Hash

  3. count, sum, Average

  4. None of the Above

Show answer
Correct Option: A

Types of lookup in parallel?
technology

  1. Normal

  2. Sparse

  3. Both

  4. None of the Above

Show answer
Correct Option: C

How will you create a Datastage Projects?(Choose two)
technology

  1. Datastage Designer

  2. Datastage Administrator

  3. Install the Datastage engine

  4. All the Above

Show answer
Correct Option: B,C

Sequential file stage can be used __________
technology

  1. Only to extract data

  2. Only to load data

  3. Only either to extract or to load

  4. Only to Transform data

  5. To extract, load or transform

Show answer
Correct Option: C

Which of the following is not a component of Sequential file stage?

technology

  1. File path

  2. File format (Fixed width or Delimited)

  3. Column definitions

  4. None of the above

Show answer
Correct Option: D

Transformer stage is used to define ________
technology

  1. Constraints

  2. Derivations

  3. Column Mappings

  4. All of the above

Show answer
Correct Option: D