Q.How do you Generate sequence at the time of Display? Answer: By Using CSUM Q.How do you Generate Sequence in Teradata? Answer: By Using Identity Column 1-for storing purpose using identity. 2-for display purpose using csum. Q.How do you load Multiple files to a table by using fast load scripts? Remove End Answer: Loading statement in the script and Replace the file one by one in the script till last file and submit every time so that data appended in Amp Level.For the last file specify End Loading statement in the script and Run.so that it ru...
- 1