|
Collapse All | Expand All | Show Default |
| BuildEtlQaSqlHash
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: 07-29-2004 |
| Full Description | Job: LoadEtlJob
------------------------------------------------------------------------------------- Non-technical description: This copies records from ETL_QA_SQL to a hash file. This allows job GetEtlQaSqlStatDriver to process the SQL to calculate row counts or whatever measures to validate the data warehouse tables. ------------------------------------------------------------------------------------- Business rules: tbd ------------------------------------------------------------------------------------- Rules for restarting this job: Just rerun. ------------------------------------------------------------------------------------- Parameters: 1. TargetDSN 2. TargetUser 3. TargetPwd ------------------------------------------------------------------------------------- Sources: ETL_QA_SQL ------------------------------------------------------------------------------------- Targets: EtlQaSqlHash ------------------------------------------------------------------------------------- Modification History: ------------------------------------------------------------------------------------- UserId Date Version Modification Description ------------------------------------------------------------------------------------- kduke 07-29-2004 1 Created job. ------------------------------------------------------------------------------------- |
| Category | EtlStats |
| Multiple Instance | False |
| Job Version Number | 40.1.1 |
| Hash File Cache Sharing | False |
| - Annotations (1) |
| # | Annotation |
| 1 | BuildEtlQaSqlHash |
| - Parameters (3) |
| Parameter Name | Prompt | Default Value | Help Text |
| TargetDSN | TargetDSN | kduke | |
| TargetUser | TargetUser | etluser | |
| TargetPwd | TargetPwd | LDH@9:VA=93L0O5I<;J| |
|
| - Stages (3) |
| - Source Stages (1) |
| ETL_QA_SQL (oraoci8) |
| - Processing Stages (1) |
| TransEtlQaSql (transformer) |
| - Target Stages (1) |
| EtlQaSqlHash (hash file) |
| - Source Stages (1) |
| - ETL_QA_SQL (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 |
| - Output Links (1) |
| - Processing Stages (1) |
| - Target Stages (1) |
| - EtlQaSqlHash (hash file) |
| - Stage Properties (2) |
| Property | Value |
| SQL Null Value | Standard DSEngine |
| UniVerse Stage Compatibility | False |
| - Input Links (1) |
