• technology Online Quiz - 1558
Back
0

technology Online Quiz - 1558

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

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

AI Explanation

To create a Datastage project, you need to perform the following steps:

  1. Install the Datastage engine: Option C is correct because you need to install the Datastage engine on the server where you want to create the project. The Datastage engine is responsible for running and managing Datastage jobs.

  2. Use the Datastage Administrator: Option B is correct because you need to use the Datastage Administrator tool to create a new project. The Datastage Administrator provides a graphical user interface to manage Datastage projects, including creating and configuring projects, managing users and roles, and setting up project-level properties.

Therefore, the correct answer is 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

Job parameter values can be determined __________

technology

  1. At Compile time

  2. At Run time

  3. At Both compile time and run time

  4. Never

Show answer
Correct Option: B

These are created within a job and are only accessible by that job

technology

  1. Shared container

  2. Local container

  3. Both

  4. None of the above

Show answer
Correct Option: B

DataStage Director can be invoked from __________

technology

  1. DataStage Designer and Administrator

  2. DataStage Administrator

  3. DataStage Designer

  4. None of the above

Show answer
Correct Option: C

Which stage is used for comparing and identifying differences between two generations of the same data source?

technology

  1. Aggregator stage

  2. Change Capture stage

  3. Modify stage.

  4. Change Apply stage

Show answer
Correct Option: B

What does a Configuration File in parallel extender consist of?

technology

  1. Number of Processes or Nodes.

  2. Actual Disk Storage Location.

  3. Fast name

  4. All the Above

Show answer
Correct Option: D

Which partitioner divides a data set into approximately equal size Partitions based on one or more partitioning keys?

technology

  1. Range

  2. Same

  3. Round Robin

  4. None of the above

Show answer
Correct Option: A

How do you execute datastage job from command line prompt?

technology

  1. dsjob -run -jobstatus projectname jobname

  2. dsjob -run projectname jobname

  3. dsjob -exec projectname jobname

  4. dsjob -exec –jobstatus projectname jobname

Show answer
Correct Option: A

Field(‘Jhon|Micky|gail|’,’|’,1) = ?

technology

  1. Micky

  2. Jhon

  4. None of the above

Show answer
Correct Option: B

TrimF(" String with whitespace ") = ?

technology

  1. " String with whitespace "

  2. Stringwithwhitespace

  3. "String with whitespace "

  4. " String with whitespace"

Show answer
Correct Option: C

These are stages that help you when you are developing and troubleshooting parallel jobs (Choose two.)

technology

  1. Transformer

  2. File

  3. Row Generator

  4. Peek

Show answer
Correct Option: C,D

These are stages that perform some processing on the data that is passing through them (Choose two.)

technology

  1. File

  2. Aggregator

  3. Transformer

  4. All of the above

Show answer
Correct Option: B,C

Which option is given to the Sequential file that allows individual files to be read by several nodes?

technology

  1. Read From Multiple Nodes

  2. Number of Readers Per Node

  3. Report Progress

  4. Pattern

Show answer
Correct Option: A

Which is not a valid statement regarding a File Set Stage?

technology

  1. 2G limit on some File systems

  2. Need to distribute data among nodes to prevent overruns

  3. If used in parallel, runs faster than sequential file

  4. No limitations for the File systems

Show answer
Correct Option: D
- 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