I have a datatable (i.e. dt_employee) in c#.net, which has around 1million records. How do i insert this dt_employee data into TeraData table EmployeeTable.
What have you tried? (always useful to know that so that we don't give you an answer you've already tried).
An obvious approach is to use the dot net data provider, but with @1million rows that will be slow. For speed you'd want to use an array insert (I'm fairly certain the DP supports this) and ideally use multiple connections. Docs for the DP are here (although this might be a slightly older version).
An alternative would be to write the data to a file on your pc and then use TPT Load/Fastload for the loading.