I have Teradata Express 13.0 for VMware (4 GB) up and running. But I could not find any test data/tables in there. Can someone direct me how to find test data where I can query? Do I have to download and run 40GB or 1TB in order to get the test data?
in TD15 I have several DB's under "Samples", there's "retail", "financial" etc. Not sure about 13
run this and you'll get some datasets to play with:
select top 50
order by CurrentPerm desc
I recently installed TDExpress184.108.40.206_Sles11_40GB_vp. However i am unable to see "Samples" DB when i query DBC.Tables. Can any one help?
The tables are not in the Samples DB itself, they are in databases below Samples in the hierarchy.
SELECT DatabaseName, TableName FROM DBC.TablesV
WHERE DatabaseName in (SELECT Child FROM DBC.ChildrenV WHERE Parent = 'Samples');