can anyone pls help me out in this subject.I have a requirement like i have to transfer a huge amount of data from SQL 2000 server to Teradata. I dont have much idea regarding this. Like if u guys tell me how i can achiev this, whether is there is any tool or simulator is there to do this or any other ways.Hoping for the genuine reply.
1.then drag the sQl Stage from the database 2. Give the connection properties. 3.import the Table you want to load 4.Drag the copy/Transform stage 5.Open Properties of copy/Transform stage drag required columns into output tab 6.Drag the Teradata API from Database then give the connection propeties 7.compile and run