07-14-2016 02:48 PM
I have a sas data set,which will update with different column names everymonth.I have to create teradata table from this dataset.How can i define the structure of the table based on SAS dataset(how to choose index variable etc) it is a huge dataset??
Ex: dataset april month:
PRSN_ID exp1 exp2 exp3
. 1 0 1
111 2 3 1
dataset May month
Name exp2 db008 behaviour
rxt 1 2 good
tuv 0 1 notbad
07-14-2016 02:56 PM
So is it the case that every month you are getting a new dataset that has no relationship to the previous month's dataset?
Do you want to load the May data into Teradata and and replace the April table in Teradata?
If you get a new dataset every month, with different column names, you would probably need to ask the provider to also provide information on keys/indexes when they deliver the data.
You can of course add your own GUID, or every month look through variables to see if you can find set of variables that would be reasonable candidates to use as an index, but that wouldn't seem very useful.
I'm perplexed by the big picture. The idea of a "dynamic table" where columns change every month does not seem very useful to me.
07-14-2016 03:03 PM
it is very huge data with 115 columns,finding solution how to load this data in the database automatically. this table is the input for 10 other processes.
07-14-2016 04:30 PM