Datastage snippets and examples

Ik ben sinds 1996 Business Intelligence consultant en implementeer datastage oplossingen sinds 2005. U kunt mij als freelance datastage consultant inhuren via mijn bedrijf Capire.

• Command window commando's
  Een aantal voorbeelden van het gebruik van het command window. Hiermee kun je bijvoorbeeld datastage jobs unlocken, read only jobs vrijgeven en informatie opvragen over jobs.
• Performance of Column propagation in Datastage
  Information about performance impact when you use Column Propagation in Datastage.
• Impact of field size on performance in Datastage
  Test to see if fields size has impact on performance.
• Impact of field size on sorter performance in Datastage
  Information about performance impact of field size in the sorter transformation.
• Remove duplicates retaining first/minimum row in Datastage
  Two methods of removing duplicates retaining first record
• Performance difference between Lookup and Join
  Information about performance difference between a lookup and a join in Datastage.
• Lookup File Sets: the hashed files for parallel jobs
  Information about reusable lookup files in Datastage
• Use a 'hidden' propagated column in a transformer
  Pickup a propagated colum with the modify stage
• Create Parallel routine in C for Datastage
  Two examples for creating a Parallel routine for Datastage.
• Example use of the pivot stage
  Example of using the pivot stage
• Snelheid van XML input verhogen met Common variabelen
  Use common variables to improve speed of XML reading.
• Compare jobs from XML exports
  Sample job that can be used to find out differences between two jobs using the XML stage.