Hi
when using the Teradata Multi Load stage how to parameterise the Table Name, User id and password instead of hardcoding those values?
i dont see any option as in DB2 enterprise stage to insert job parameters in teradata mload stage.
is there a way to do it?
Teradata Multi Load Stage..How to Parameterise?
Moderators: chulett, rschirm, roy
Re: Teradata Multi Load Stage..How to Parameterise?
Hi,
You do not have a option of browsing to enter the job parameter.You need to so something like this :
Declare the table name, userid,pass word,server etc in job parameter, and need to call them in the stage in between slashes :#tablename#and#userid#,so on. Check it
You do not have a option of browsing to enter the job parameter.You need to so something like this :
Declare the table name, userid,pass word,server etc in job parameter, and need to call them in the stage in between slashes :#tablename#and#userid#,so on. Check it
when using the Teradata Multi Load stage how to parameterise the Table Name, User id and password instead of hardcoding those values?
i dont see any option as in DB2 enterprise stage to insert job parameters in teradata mload stage.
is there a way to do it?
All the plugins that I've encountered behave in this way. They seem to have the old-school server style method of entering parameters. It is particularily annoying on the MultiLoad plugin because there are so many settings, and Teradata installations usually have strict requirements on how these should be set.
I recommend setting up one Multiload Job with Parameters and cut and paste it where necessary onto other jobs.
Good luck,
Greg
I recommend setting up one Multiload Job with Parameters and cut and paste it where necessary onto other jobs.
Good luck,
Greg