DataStage is a Rapid
Application Development tool for building data warehouses or doing data
conversions also know as ETL tools. RAD tools can rapidly create a disorganized
mess. DwNav will help you organize this mess and help you find the process or
job you need to change. DwNav helps you browse directly on top of the business
rules. DwNav also helps you create best practices around DataStage. Best
practices are really a Quality Assurance process to make sure exports are done
in an organized way or metadata is consistent across a job. Best practices
also says we are tracking the performance of our jobs. How long does our whole
ETL take? Is this time taking longer than the last time? Can we speed this up?
How much work is involved in changing my ETL? How many steps or objects did
the developers create to build one job or a series of jobs? DwNav can help you
answer these questions.
DwNav can help DataStage developers
quickly browse transformations. A typical process a developer
would go through is to add a column to a target table. With DwNav you can
quickly find the DataStage job which built that target table and trace it
back through that job to the previous job all the way to the source tables.
This is especially important if you were not the original developer and
the original developer is no longer available. DataStage allows the developer
to quickly create hundreds if not thousands of jobs. All the business rules for
the transformations are buried down in the DataStage Designer GUI.
Key Benefits
• Without Designer a non-technical user can view job’s business rules.
• Jump from business rules to Designer with one click.
• Find all jobs reading source table or any type of file like hash or sequential.
• Find all jobs updating target table or any type of file like hash or sequential.
• Show source job for lookup tables within dependant job.
• Trace derivations from link to link back to source.
• Elegant documentation showing long description, source, reference and target tables.
• Drill down into many levels of job sequences.
• Browse run time job duration history.
• Browse run time parameter value history.
• Browse run time row count history.
• Browse run time row per second history.
• Do performance analysis by viewing row per second changes over time.
• Do performance analysis by viewing job duration changes over time.
• Do metadata mismatch analysis which compares source metadata to target.
• Find all jobs using a specific parameter.
• View constraints.
• View SQL.
• View ETL column metadata.
• View parameter metadata.
• View routine source and arguments.
• View before/after routines for jobs and stages.
• Parse exports into one file per job.
• Check in job exports with one click into any version control software.
• Works with DataStage 5, 6 and 7.
•
|
Description
|
Product
|
Price
|
|
30 day trial
|
Developer Version
|
Free
|
|
Developer (individuals only)
|
Developer Version
|
contact us
|
|
DwNav Corporate
|
Enterprise Version
|
contact us
|
For 7 day free trial auth code:
Kim_G_Duke@hotmail.com
