Home Page for the TeradataForum

Archives of the TeradataForum

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

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

Subj:   Re: Does Informatica +really+ force MultiLoad worktables into the target database?
From:   Dwight Etheridge


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>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020