Table Iterator to Dump data from teradata to Redshift
I am using Table Iterator on top of DB connector (Teradata) with one Table input to iterate table_name one by one and dump data from terdata to redshift Target table. which seems working and iterating on tables with feed sql (select * from ) but some how copy statement is not loading any data. Can any one please suggest.
4 Community Answers
Kalyan Arangam —
Do you see any errors?
I’ve only seen this when we do not pull any data from source.
Are you able to share your log file from Admin menu?
Don't see any error, Task status says the count of the source table but no error. I have checked the log with copy statement generating after every iteration.How do I debug or Any other approach to load data from teradata to redshift with list of tables .Please suggest.