Tag: technology

Questions Related to technology

When to use a copy stage in the job
technology

  1. Replicating data set

  2. Change the data type

  3. Renaming the Field name

  4. A and C

Show answer
Correct Option: D

Where can the option to set character map be found in a stage
technology

  1. general tab

  2. NLS map tab

  3. Advanced tab

  4. None of the above.

Show answer
Correct Option: B

Which are right, option regarding the Switch Stage?
technology

  1. It can have n number of input and n number of output

  2. It can have 1 input link and 128 output links

  3. It can have 1 input link and 127 output links

  4. It can have 2 input links and 127 output links

Show answer
Correct Option: B

Which Environmental variable should be set to verify that runtime schemas match the job design column definitions (especially from Oracle).

technology

  1. OSH_DUMP

  2. OSH_PRINT_SCHEMAS

  3. APT_DUMP_SCORE

  4. APT_NO_JOBMON

Show answer
Correct Option: B

Which one of the following is valid about LookupFileSet stage?
technology

  1. Output link is a reference link.

  2. Input link is a reference link.

  3. output link is a non-reference link

  4. None of the above.

Show answer
Correct Option: A

What type of sorting can be used in datastage?
technology

  1. unique sort

  2. stable sort

  3. bubble sort

  4. sync sort

Show answer
Correct Option: A

Which of the following stage is used as a stub in an iterative development?
technology

  1. Sequential Stage

  2. File Set Stage

  3. Copy Stage

  4. DataSet Stage

Show answer
Correct Option: C

What type of stage is a dataset stage?
technology

  1. BuildOP stage

  2. File stage

  3. Processing stage

  4. Database stage

Show answer
Correct Option: B

How the data can be read from the output of one or more source programs
technology

  1. External Source Stage

  2. External Target Stage

  3. Complex Flat File Stage

  4. Internal File Stage

Show answer
Correct Option: A

What is the hierarchy in DataStage
technology

  1. Project, category, jobs

  2. Category, jobs, project

  3. Jobs, project, category

  4. Project, jobs, category

Show answer
Correct Option: D