|
Collapse All | Expand All | Show Default |
| LoadEtlJobLink
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: LoadEtlJobLink
------------------------------------------------------------------------------------- Non-technical description: Load link names from DS_JOBOBJECTS. ------------------------------------------------------------------------------------- Business rules: Runs from SqlPrepareStats. ------------------------------------------------------------------------------------- Rules for restarting this job: Just rerun. ------------------------------------------------------------------------------------- Parameters: 1. TargetDSN 2. TargetUser 3. TargetPwd ------------------------------------------------------------------------------------- Sources: DS_JOBOBJECTS ------------------------------------------------------------------------------------- Targets: ETL_JOB_LINK ------------------------------------------------------------------------------------- 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 | LoadEtlJobLink |
| - 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) |
| DsJobLinks (uv stage) |
| - Processing Stages (1) |
| TransDsJobLinks (transformer) |
| - Target Stages (1) |
| ETL_LINK (oraoci8) |
| - Source Stages (1) |
| - DsJobLinks (uv stage) |
| - Processing Stages (1) |
| - TransDsJobLinks (transformer) |
| + Stage Variables (0) |
| - Input Links (1) |
| - Output Links (1) |
| + ETL_LINK triggers ETL_LINK when index(DsJobLinks.LINK_TYPE, "Activity", 1)=0 and index(DsJobLinks.LINK_TYPE, "Trx", 1)=0 and DsJobLinks.JOB_CATEGORY[1,4] <> "User" and DsJobLinks.JOB_CATEGORY[1,1] <> "z" and upcase(DsJobLinks.JOB_NAME[1,1]) <> "Z" and upcase(DsJobLinks.JOB_NAME[1,1]) <> "X" |
| - Target Stages (1) |
| - ETL_LINK (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) |
