Datastage Certification

Datastage V 8.5  – Test 000-421 (IBM link – http://www-03.ibm.com/certify/tests/ovr421.shtml)

Get free Dumps cheap  – http://ds.iexpertify.com/2013/09/datastage-certification-dumps-for-v8-5-000-421.html
(Note for copyright: iexpertify.com does not host datastage certification dumps)

Test information:
  • Number of questions: 65
  • Time allowed in minutes: 90
  • Required passing score: 65%

To register, click on the IBM link and follow the IBM at Prometric link at the right of the webpage.

If you are taking the IIS Datastage certification, these are the topics you will be tested on:

Section 1 – Configuration (6%)
  1. Describe how to properly configure DataStage v8.5
  2. Identify tasks required to create and configure a project to be used for v8.5 jobs
  3. Given a configuration file, identify its components and its overall intended purpose


Section 2 – Metadata (6%)
  1. Demonstrate knowledge of Orchestrate schema
  2. Identify the method of importing, sharing, and managing metadata
  3. Demonstrate knowledge of runtime column propagation


Section 3 – Persistent Storage (10.5%)
  1. Explain the process of importing/exporting data to/from framework (e.g., sequential file, external source/target)
  2. Describe proper use of a sequential file
  3. Describe proper usage of FileSets and DataSets
  4. Describe use of FTP stage for remote data
  5. Describe use of restructure stages (e.g., column import/export)
  6. Identify importing/exporting of XML data


Section 4 – Parallel Architecture (9%)
  1. Demonstrate proper use of data partitioning and collecting
  2. Demonstrate knowledge of parallel execution


Section 5 – Datatbases (9%)
  1. Demonstrate proper selection of database stages and database specific stage properties
  2. Identify source database options
  3. Demonstrate knowledge of target database options


Section 6 – Data Transformation (12%)
  1. Demonstrate knowledge of default type conversions, output mappings, and associated warnings
  2. Demonstrate proper selections of Transformer stage vs. other stages
  3. Describe Transformer stage capabilities (including: stage variables, link variables, DataStage macros, constraints, system variables, link ordering, @PART NUM, functions
  4. Demonstrate the use of Transformer stage variables (e.g., to identify key grouping boundaries on incoming data)
  5. Identify process to add functionality not provided by existing DataStage stages. (e.g., wrapper, BuildOps, user def functions/routines)
  6. Demonstrate proper use of SCD stage
  7. Demonstrate job design knowledge of using RCP (modify, filter, dynamic transformer)
  8. Demonstrate knowledge of Transformer Stage input and output loop processing (e.g., LastRecord(), LastRowInGroup(), SaveRecord(), etc.)


Section 7 – Job Components (12%)
  1. Demonstrate knowledge of Join, Lookup and Merge stages
  2. Demonstrate knowledge of SORT stage
  3. Demonstrate understanding of Aggregator stage
  4. Describe proper usage of change capture/change apply
  5. Demonstrate knowledge of Real-time components


Section 8 – Job Design (9%)
  1. Demonstrate knowledge of shared containers
  2. Describe how to minimize Sorts and repartitions
  3. Demonstrate knowledge of creating restart points and methodologies
  4. Demonstrate proper use of standards
  5. Explain the process necessary to run multiple copies of the source (job multi-instance)


Section 9 – Monitor and Troubleshoot (7%)
  1. Demonstrate knowledge of parallel job score
  2. Identify and define environment variables that control DataStage v8.5 with regard to added functionality and reporting
  3. Given a process list, identify conductor, section leader, and player process
  4. Identify areas that may improve performance (e.g., buffer size, repartitioning, config files, operator combination, etc.)
  5. Demonstrate knowledge of runtime metadata analysis and performance monitoring


Section 10 – Job Management and Deployment (10.5%)
  1. Demonstrate knowledge of advanced find
  2. Demonstrate knowledge and the purpose of impact analysis
  3. Demonstrate knowledge and purpose of job compare
  4. Articulate the change control process
  5. Source Code Control Integration


Section 11 – Job Control and Runtime Management (6%)
  1. Demonstrate knowledge of message handlers
  2. Identify the use of dsjob command line utility
  3. Demonstrate ability to use job sequencers (e.g., exception hunting, re-startable, dependencies, passing return value from routing, parameter passing and job status)

40 thoughts on “Datastage Certification

  1. says

    Hi Ananth
    I also want to do 421 certification. But have some issues with syllabus, if you have some guides or dump of this certification Can you please provide ?

  2. says

    this is the best dumps I have for V8.5. if you want to take 000-303
    IBM InfoSphere DataStage v9.1, IBM Certified Solution Developer – InfoSphere DataStage v9.1. I don’t have any dumps yet. I will share if someone can send it to me.

  3. Sheetal says

    Hi

    I am looking for Datastage (C2090-421: InfoSphere DataStage v8.5) dumps, If you have please share, I will be thankful to you.

    • karthick says

      Hi

      I am looking for Datastage (C2090-421: InfoSphere DataStage v8.5) dumps, If you have please share, I will be thankful to you.

  4. Hari says

    I am taking up IBM Infosphere Datastage 9.1 certification, If anyone has dumps, please send it to my email id: [email protected]
    In case if you have datastage 8.5 dumps, please forward the same.

    Thanks in Advance
    itshari

Leave a Reply to Sree Cancel Reply

Your email address will not be published.