|
Collapse All | Expand All | Show Default |
| LoadEtlJob
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: Load ETL_JOB to use in reports to pull in job category. ------------------------------------------------------------------------------------- Business rules: Runs from SeqPrepareEtlStats. ------------------------------------------------------------------------------------- Rules for restarting this job: Just rerun. ------------------------------------------------------------------------------------- Parameters: 1. TargetDSN 2. TargetUser 3. TargetPwd ------------------------------------------------------------------------------------- Sources: ETL_JOB_HIST ------------------------------------------------------------------------------------- Targets: ETL_JOB ------------------------------------------------------------------------------------- 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 | LoadEtlJob |
| - 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_JOB_HIST (oraoci8) |
| - Processing Stages (1) |
| TransEtlJobHist (transformer) |
| - Target Stages (1) |
| ETL_JOB (oraoci8) |
| - Source Stages (1) |
| - ETL_JOB_HIST (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) |
| - TransEtlJobHist (transformer) |
| + Stage Variables (0) |
| - Input Links (1) |
| - Output Links (1) |
| + ETL_JOB triggers ETL_JOB when KgdIsJobSequence(ETL_JOB_HIST.JOB_NAME) |
| - Target Stages (1) |
| - ETL_JOB (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) |
