July 29, 2018

Analytics Skills - Technology DataStage-L1


Question.
Continue action if a lookup on a link fails

a)Drops the row and Job fails
b)Drops the row and will skip next lookup
c) Drops the row and will skill all further lookups
d) Drops the row and continues with the next lookup

Answer: Drops the row and continues with the next lookup

Question.
Fail action if a lookup on a link fails

a) Causes the job to reject records
b) Causes the job to issue a fatal error and continues with next lookup
c) Causes the job to issue a fatal error and stop
d) Causes the job to issue a fatal error and falls records from subsequent lookup

Answer: Causes the job to issue a fatal error and stop

Question.
Which phase is used to compute sum of salary collected together by deptno?
a)Join
b)Aggregate
c)Merge
d) Copy

Answer: Aggregate

Question.
Which activity is used to execute shell scripts or bat files?

a) Wait for File activity
b) Execute Command activity
c) Program activity
d) Run Program activity

Answer: Execute Command activity

Question.
Change_Code value of three of Change Capture Stage in DataStage represents

a) Copy
b) Delete
c) New
d) Edit

Answer: Edit

Question.
Change_Code value of zero of Change Capture Stage in DataStage represents

a) Edit
b) Delete
c) New
d) Copy

Answer: Copy

Question.
Change_Code value of one of Change Capture Stage in DataStage represents
a) Copy
b) Delete
c) Edit
d) New

Answer: New

Question.
Which one is used to remove duplicates in data?

a) Unique property set in Join Stage
b)Unique property set in Merge Stage
c)Remove Duplicate Stage
d)Dedup Sort Stage

Answer: Remove Duplicate Stage

Question.
Which of the below stages are used to achieve Union all operation on input data sources?

a)Join
b) Funnel
c) Lookup
d) Filter

Answer: Funnel

Question.
Which of the following is not type of view in Datastage Director?

a)Job View
b)Log View
c)Status View
d) Parallel View

Answer: Parallel View

Question.
Which one of the following can be used to schedule jobs

a) DataStage Director
b)DataStage Designer
c)DataStage Administrator
d) Data Stage Exporter

Answer: DataStage Director

Question.
Which one is used to create workflows in DataStage?

a) Parallel Jobs
b) Sequence Jobs
c) Server Jobs
d) Workflow Activity

Answer: Sequence Jobs

Question.
Change_Code value of two of Change Capture Stage in DataStage represents

a) Copy
b) Delete
c) New
d) Edit

Answer: Delete

Question.
Change Capture stage is

a) File Stage
b) Database Stage
c) Processing Stage
d) Miscellaneous Stage

Answer: Processing Stage

Question.
Which Stage allows you to specify several Reject links?

a) Lookup
b)Merge
c)Join
d) filter

Answer: Merge

Question.
If two rows in Change Capture have same key columns, you can match the columns in the rows to understand if one is an modified copy of the other.

a) Key Column
b) Value Columns
c)After Data Column
d)Before Data Column

Answer: Value Columns

Question.
Which action will wait for file to seem in a folder?

a)Wait for file activity
b)Job Activity
c)Execute Command Activity
d)Sequential file Stage activity

Answer: Wait for file activity

Question.
Which of the below phases are used to Restrict Data created on Where Clause Predicates?

a)Join
b)Funnel
c) Filter
d) Copy

Answer: Filter

Question.
using Copy stage

a)Order of columns can be changed but data type of columns cannot be changed
b)Order of columns cannot be changed but data type of columns can be changed
c)Order of columns can be changed and data type of columns can be changed
d) both the Order of columns and data type of columns cannot be changed

Answer: Order of columns can be changed but data type of columns cannot be changed

Question.
Which option will send record with null values when a lookup failure happens

a) Reject
b) Drop
c) Fail
d) Continue

Answer: Continue