DSXchange

Hi All, I'm testing the Teradata stages for the first time since the installation and I'm having a problem using MultiLoad and Tpump. The Enterise Stage work fine. Is there a specfic path DataStage needs to point to to find the mload executable? I'm assuming that this is what is causing the error.

mload: No such file or directory



.logtable SMB_DEV_TABLE.LOGT_CD_DDT_DimDate;

.logon 142.182.194.146 142.182.194.148 142.182.194.145 142.182.194.147/DATA_STAGE,PASSWORD;

.begin import mload tables SMB_DEV_TABLE.T_CD_DDT_DimDate CHECKPOINT 0 TENACITY 2;

.layout internal indicators;

.field DDT_Key * integer;

.field DDT_Date * char(26);

.field DDT_DateDesc * varchar(25);

.field DDT_DayOfWeek * integer;

.field DDT_MonthDesc * varchar(20);

.field DDT_MonthNum * integer;

.field DDT_QuarterDesc * varchar(20);

.field DDT_QuarterNum * integer;

.field DDT_Year * integer;

.field DDT_WeekStartDate * date;

.field DDT_WeekEndDate * date;

.field DDT_DayOfWeekDesc * varchar(20);

.field DDT_FiscalYear * integer;

.field DDT_FiscalWeekStartDate * date;

.field DDT_FiscalWeekEndDate * date;

.field DDT_FiscalQuarterNum * integer;

.field DDT_FiscalQuarterDesc * varchar(20);

.field DDT_PreviousYear * integer;

.field DDT_WeekNum * integer;

.field DDT_PreviousWeekNum * integer;

.field DDT_PreviousQuarterNum * integer;

.field DDT_PreviousMonthNum * integer;

.field DDT_PreviousDayOfWeek * integer;

.field DDT_FiscalQuarterStartDate * date;

.field DDT_FiscalQuarterEndDate * date;

.field DDT_HolidayIndicator * varchar(20);

.field DDT_Weekday_Indicator * varchar(20);

.dml label tdmload do insert for missing update rows;

update SMB_DEV_TABLE.T_CD_DDT_DimDate

set DDT_Date = :DDT_Date,

DDT_DateDesc = :DDT_DateDesc,

DDT_DayOfWeek = :DDT_DayOfWeek,

DDT_MonthDesc = :DDT_MonthDesc,

DDT_MonthNum = :DDT_MonthNum,

DDT_QuarterDesc = :DDT_QuarterDesc,

DDT_QuarterNum = :DDT_QuarterNum,

DDT_Year = :DDT_Year,

DDT_WeekStartDate = :DDT_WeekStartDate,

DDT_WeekEndDate = :DDT_WeekEndDate,

DDT_DayOfWeekDesc = :DDT_DayOfWeekDesc,

DDT_FiscalYear = :DDT_FiscalYear,

DDT_FiscalWeekStartDate = :DDT_FiscalWeekStartDate,

DDT_FiscalWeekEndDate = :DDT_FiscalWeekEndDate,

DDT_FiscalQuarterNum = :DDT_FiscalQuarterNum,

DDT_FiscalQuarterDesc = :DDT_FiscalQuarterDesc,

DDT_PreviousYear = :DDT_PreviousYear,

DDT_WeekNum = :DDT_WeekNum,

DDT_PreviousWeekNum = :DDT_PreviousWeekNum,

DDT_PreviousQuarterNum = :DDT_PreviousQuarterNum,

DDT_PreviousMonthNum = :DDT_PreviousMonthNum,

DDT_PreviousDayOfWeek = :DDT_PreviousDayOfWeek,

DDT_FiscalQuarterStartDate = :DDT_FiscalQuarterStartDate,

DDT_FiscalQuarterEndDate = :DDT_FiscalQuarterEndDate,

DDT_HolidayIndicator = :DDT_HolidayIndicator,

DDT_Weekday_Indicator = :DDT_Weekday_Indicator

where DDT_Key = :DDT_Key;

insert SMB_DEV_TABLE.T_CD_DDT_DimDate (DDT_Key, DDT_Date, DDT_DateDesc, DDT_DayOfWeek, DDT_MonthDesc, DDT_MonthNum, DDT_QuarterDesc, DDT_QuarterNum, DDT_Year, DDT_WeekStartDate, DDT_WeekEndDate, DDT_DayOfWeekDesc, DDT_FiscalYear, DDT_FiscalWeekStartDate, DDT_FiscalWeekEndDate, DDT_FiscalQuarterNum, DDT_FiscalQuarterDesc, DDT_PreviousYear, DDT_WeekNum, DDT_PreviousWeekNum, DDT_PreviousQuarterNum, DDT_PreviousMonthNum, DDT_PreviousDayOfWeek, DDT_FiscalQuarterStartDate, DDT_FiscalQuarterEndDate, DDT_HolidayIndicator, DDT_Weekday_Indicator)

values (:DDT_Key, :DDT_Date, :DDT_DateDesc, :DDT_DayOfWeek, :DDT_MonthDesc, :DDT_MonthNum, :DDT_QuarterDesc, :DDT_QuarterNum, :DDT_Year, :DDT_WeekStartDate, :DDT_WeekEndDate, :DDT_DayOfWeekDesc, :DDT_FiscalYear, :DDT_FiscalWeekStartDate, :DDT_FiscalWeekEndDate, :DDT_FiscalQuarterNum, :DDT_FiscalQuarterDesc, :DDT_PreviousYear, :DDT_WeekNum, :DDT_PreviousWeekNum, :DDT_PreviousQuarterNum, :DDT_PreviousMonthNum, :DDT_PreviousDayOfWeek, :DDT_FiscalQuarterStartDate, :DDT_FiscalQuarterEndDate, :DDT_HolidayIndicator, :DDT_Weekday_Indicator);

.import INFILE Teradata_Multiload_22.DateDim format fastload layout internal apply tdmload;

.end mload;

.if &SYSETCNT then;

.logoff 20;

.endif;

.if &SYSUVCNT then;

.logoff 20;

.endif;

.logoff;

You have to specify the path of Mload file and log file in Teradata Stage.
The Mload file will have the SQL that you have defined. Log file has the number of records inserted/updated in this run. If you want you can give the names of Error tables also in teradata stage

Thanks for repsonse, I don't see where in the Stage I would put the path information. Please be more specific

Click on input tab of TD stage. And click on MultiLoad/TPump sub-tab.