0

technology Online Quiz - 1557

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

Which client tool is used for Datastage Version Control?

  1. DataStage Administrator

  2. DataStage Director

  3. DataStage Manager

  4. DataStage Designer


Correct Option: A

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

  1. Unix command line interface

  2. System dll

  3. APT_dump

  4. APT_Operator


Correct Option: D

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

  1. Import operator

  2. APT combined controller

  3. Modify operator

  4. None of the above


Correct Option: B

Why Lookup File set must need a Key column?

  1. Remove Duplicates

  2. Memory Limit

  3. Reference to a Lookup

  4. None of above


Correct Option: A

How will you take rejects from Transformer stage?

  1. Using Otherwise log

  2. Using Constraints

  3. Using functions

  4. All the above


Correct Option: A

What are the operations performed in modify stage?

  1. Null handling

  2. Type conversion

  3. Dropping a particular column

  4. All the above


Correct Option: D

How datastage makes decision on which configuration file to use

  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


Correct Option: D

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

  1. Primary Link

  2. Update Link

  3. Number of Records

  4. All the above


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

  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


Correct Option: D

Which of the below statements is true about configuration file

  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


Correct Option: D

How to override default settings of environmental variables through datastage client

  1. Datastage Administrator

  2. Datastage Designer

  3. Datastage Director

  4. All of the above


Correct Option: D

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

  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


Correct Option: D

When to use a copy stage in the job

  1. Replicating data set

  2. Change the data type

  3. Renaming the Field name

  4. A and C


Correct Option: D

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

  1. general tab

  2. NLS map tab

  3. Advanced tab

  4. None of the above.


Correct Option: B

Which are right, option regarding the Switch Stage?

  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


Correct Option: B

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

  1. OSH_DUMP

  2. OSH_PRINT_SCHEMAS

  3. APT_DUMP_SCORE

  4. APT_NO_JOBMON


Correct Option: B

Which one of the following is valid about LookupFileSet stage?

  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.


Correct Option: A

What type of sorting can be used in datastage?

  1. unique sort

  2. stable sort

  3. bubble sort

  4. sync sort


Correct Option: A

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

  1. Sequential Stage

  2. File Set Stage

  3. Copy Stage

  4. DataSet Stage


Correct Option: C
  1. BuildOP stage

  2. File stage

  3. Processing stage

  4. Database stage


Correct Option: B
- Hide questions