IBM 000-303 valid exam dumps : IBM Certified Solution Developer - IBM InfoSphere DataStage

The Score is divided into which two sections? (Choose two.)

• A. Operators
• B. Data sets
• C. File sets
• D. Schemas
• E. Stages

Identify the two delimiter areas available to be configured in the Sequential File format tab properties? (Choose two.)

• A. End of group delimiter
• B. File delimiter
• C. Final delimiter
• D. Null delimiter
• E. Field delimiter

Rows of data going into a Transformer stage are sorted and hash partitioned by the Input.Product column. Using stage variables, how can you determine when a new row is the first of a new group of Product rows?

• A. Create a stage variable named sv_IsNewProduct and follow it by a second stage variable
  named sv_Product. Map the Input.Product column to
  sv_Product. The derivation for sv_IsNewProduct is: IF Input.Product <> sv_Product THEN "YES"
  ELSE "NO".
• B. Create a stage variable named sv_IsNewProduct and follow it by a second stage variable
  named sv_Product. Map the Input.Product column to
  sv_Product. The derivation for sv_IsNewProduct is: IF Input.Product = sv_Product THEN "YES"
  ELSE "NO".
• C. Create a stage variable named sv_Product and follow it by a second stage variable named
  sv_IsNewProduct. Map the Input.Product column to
  sv_Product. The derivation for sv_IsNewProduct is: IF Input.Product <> sv_Product THEN "YES"
  ELSE "NO".
• D. Create a stage variable named sv_Product and follow it by a second stage variable named
  sv_IsNewProduct. Map the Input.Product column to
  sv_Product. The derivation for sv_IsNewProduct is: IF Input.Product = sv_Product THEN "YES"
  ELSE "NO".

You are asked by management to document all jobs written to make future maintenance easier. Which statement is true about annotations?

• A. The short job description can be identified within the Description Annotation stage.
• B. The background for the Description Annotation stage can be changed for each unique stage.
• C. The Description Annotation stage can be added several times at different locations to identify business logic.
• D. The Description Annotation stage contains both the short and full descriptions for the job.

What are two statistics or attributes that can be added to the output of a Data Rule stage? (Choose two.)

• A. Number of violations
• B. System timestamp
• C. Percentage of violations
• D. Job execution owner
• E. Record ID