• technology Online Quiz - 1557
Back
0

technology Online Quiz - 1557

Description: technology Online Quiz - 1557
Number of Questions: 20
Created by:
Tags: technology
Start the Quiz
Attempted 0/20 Correct 0 Score 0
‹
›

Which client tool is used for Datastage Version Control?

technology

  1. DataStage Administrator

  2. DataStage Director

  3. DataStage Manager

  4. DataStage Designer

Show answer
Correct Option: A

OSH operator is an instance of a c++ class inheriting from

technology

  1. Unix command line interface

  2. System dll

  3. APT_dump

  4. APT_Operator

Show answer
Correct Option: D

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

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
- Hide questions
ADVERTISEMENT

Find more quizzes from top tags

general knowledge
3615 Quizzes
119858 Questions
 technology
307 Quizzes
36705 Questions
 sports
963 Quizzes
19148 Questions
 history
1187 Quizzes
13475 Questions
 physics
598 Quizzes
13441 Questions
 biology
1160 Quizzes
12174 Questions
 science & technology
551 Quizzes
11015 Questions
 chemistry
490 Quizzes
9892 Questions
 maths
518 Quizzes
9324 Questions
 softskills
0 Quizzes
7131 Questions