Load data from sql-server to Netezza using FIFO
Closed - This job posting has been filled.
i need to know how can i load data from SQL-Server to Netezza tables using Named-pipes (FIFO) through NZLoad , but the SQLServer and Netezza are on two different servers ,
But I do not want to do the BCP from SQLServer to Flat-file then FTP the Flatfile to Netezza Server then use this Flat-file for NZLoad because it requires me to store huge amount of flat-file data temporarily in both the servers so is why i like to use FIFO to avoid the temporary storing of data
Both the Netezza and SQL Servers are in two different UnixBoxes so i am curious if we can read the Named pipe from SQL Server Unixbox in to Netezza Unixbox without breakage.