|
Collapse All | Expand All | Show Default |
| GetEtlQaSqlStat
DataStage Job Report Generated 2005-02-15 08:26:49pm |
| - Job Design |
|
|---|
| - Job Information |
| - Job Properties (7) |
| Property | Value |
| Object Type | Server |
| Short Description | Last Changed: 11-01-2004 |
| Full Description | Job: GetEtlQaSqlStat
------------------------------------------------------------------------------------- Non-technical description: Compare measures like row counts between source and target tables. ------------------------------------------------------------------------------------- Business rules: Need to manually load ETL_QA_SQL. ------------------------------------------------------------------------------------- Rules for restarting this job: Just rerun. ------------------------------------------------------------------------------------- Parameters: 1. StatDSN 2. StatUser 3. StatPwd 4. TableName 5. SqlToRun 6. StatId 7. TargetDSN 8. TargetUser 9. TargetPwd ------------------------------------------------------------------------------------- Sources: tbd ------------------------------------------------------------------------------------- Targets: tbd ------------------------------------------------------------------------------------- Modification History: ------------------------------------------------------------------------------------- UserId Date Version Modification Description ------------------------------------------------------------------------------------- kduke 11-01-2004 1 Created job. ------------------------------------------------------------------------------------- |
| Category | EtlStats |
| Multiple Instance | True |
| Job Version Number | 40.1.1 |
| Hash File Cache Sharing | False |
| - Annotations (1) |
| # | Annotation |
| 1 | GetEtlQaSqlStat |
| - Parameters (9) |
| Parameter Name | Prompt | Default Value | Help Text |
| StatDSN | DSN to run stat | kduke | |
| StatUser | StatUser | etluser | |
| StatPwd | StatPwd | etluser | |
| TableName | Enter table | TIME_DIM | |
| SqlToRun | sql to run | select count(*) from TIME_DIM | |
| StatId | Stat Id | DealOrder1 | |
| TargetDSN | Enter Oracle DSN | kduke | |
| TargetUser | Enter Oracle User | etluser | |
| TargetPwd | Enter Password | etluser |
| - Stages (4) |
| - Source Stages (1) |
| OraStatTable (oraoci8) |
| - Processing Stages (1) |
| XfmStat (transformer) |
| - Target Stages (2) |
| QaStatResult (hash file) |
| ETL_QA_RESULT (oraoci8) |
| - Source Stages (1) |
| - OraStatTable (oraoci8) |
| - Stage Desc |
| #StatDSN#
#StatUser# #StatPwd# |
| - Stage Properties (4) |
| Property | Value |
| DATABASE | #StatDSN# |
| USERID | #StatUser# |
| PASSWORD | HD:@IIVH=9;<0OFIDJJ<3KI7F4= |
| ISOPS | NO |
| - Output Links (1) |
| - Processing Stages (1) |
| - Target Stages (2) |
| - QaStatResult (hash file) |
| - Stage Properties (2) |
| Property | Value |
| SQL Null Value | Standard DSEngine |
| UniVerse Stage Compatibility | False |
| - Input Links (1) |
| - ETL_QA_RESULT (oraoci8) |
| - Stage Desc |
| #TargetDSN#
#TargetUser# #TargetPwd# |
| - Stage Properties (4) |
| Property | Value |
| DATABASE | #TargetDSN# |
| USERID | #TargetUser# |
| PASSWORD | HD:@I:V@L93?0GEI<;J<0K1GB |
| ISOPS | NO |
| - Input Links (1) |
