Archives of the TeradataForum

Message Posted: Thu, 26 Apr 2007 @ 17:01:33 GMT

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

The reason I mentioned the 2Gb filesize is that the Informatica 'Is Staged' option writes the pipe to a file before it begins the load operation. This is a possible scenario why it works when piping and not once you check 'is Staged'. When 'Is Staged' is checked, you should be able to find a file named *.out in your $Data Directory. Check the filesize. Note, this is not a problem with 64bit unix.

If you do not have 'is Staged' checked, then Informatica pipes to the load utility. You are correct, while piping, the 2Gb limit does not apply.

Informatica handles when to use the access module and when not to. You can validate this by looking at the *.ctl file created by Informatica in your $Data directory. This contains the load utility code. You could post examples to this forum so others more familiar with Teradata (and less familiar with Informatica) can help resolve the problem.

If you do not have 'Is Staged' checked, you should also set Checkpoint to 0. If the Load operation fails and is restarted, Teradata will try to resume at the last checkpoint and look for the source file. Since the source was a pipe and the pipe was broken, it cannot find the data to use to restart.

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