Archives of the TeradataForum

Message Posted: Fri, 17 Jan 2004 @ 01:31:02 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

John,

I recall a thread a few months back by Chris Coffing that said something to this effect:

1. Run your workflow once

2. capture the generated .ctl file in the TgtFiles directory of Informatica (assuming unix pmserver)

3. change the code to point worktables, errortable to where you want, save it

4. chmod the .ctl file so that it's read only

Infa will then not generate a new one everytime. I've never tried it personally. You might scan the forum archive for that thread and other lively threads regarding "that ETL tool"

--
Dwight Etheridge
Teradata Certified Master

	<Prev	Next>		<<First	<Prev	Next>	Last>>