ETL and Data Integration tools - Modern ETL software for everyone

Hi,

I am new to AETL. My first sample project is to import data from a text file into an Oracle database table. Mapping all the fields works without problems. Now I want to fill some columns with values coming from Oracles pseudo columns like

SEQUENCER.NEXTVAL or SYSDATE.

I tried to use Literals but data import is always failing

regards,
Isa

As far is I am aware there are only two oracle pseudo columns rowid and rowno and no one can insert them

any way click on data writer
click on writer tab
click Show definition
Set mapping type to sql function
and type sysdate and seq.nextval

I believe it only works for conventional path loading

Peter