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
