Does teradata have the concept of a linked server? I would like to create a view on our Teradata Test Box which views a Dataset on the Production server.
I know that datamover could be scripted to bring the data across but space on the test server is at a premium.
Does anyone know of any other mechism that could be utilised in this senario?
Thanks in advance & I look forward to the responses
USL? Can you refer to this link.
Either way you are going to move the data even if it is a seamless process that you don't see. There are features coming that provide the Teradata equivalent of db links.
Upcoming Teradat Query Grid is going to provide this functionality but for now moving data across is only way, either via Data Mover or manually.