Does clover etl have mload option to load data from oracle to teradata. if so please help me out in doing so
Hello,
CloverETL doesn’t have Teradata bulk loader. To load data from Oracle to Teradata, you need to unload data from Oracle with DBInputTable and load it to Teradata with DBOutputTable.
You could use SystemExecute to funnel CloverETL data records into mload. SystemExecute allows you to read records from input port, format them into text representation and then send them through STDIN to mload for uploading into DB.
You may also look at Clover’s Oracle bulk loader and just modify it for mload. Mload seems to allow reading data from STDIN which makes this a lot easier.
hi ,
Could you tell me how to use this systemexecute . What should be given in the system command
Hi,
Check our wiki: http://wiki.cloveretl.org/doku.php?id=components:others#system_execute