Interested to Buy Any Domain ? << Click Here >> for more details...
How to delete the data in dataset?types of deleting the data
in dataset?
- 4 Answers
- 24817 Views
- HSBC, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / shilpasagar
We can delete the data in the dataset in 2 ways
1) Use Orchadmin command (orchadmin rm abc.ds)
2) Through Dataset Management option that is available in
the Director Client
| Is This Answer Correct ? | 16 Yes | 0 No |
Answer / venkat
We have two types of ways is there,
first one, we have to go dataset management in delete option
is there, and second one is via unix command
$orchadmin truncate[-f or -x] descriptor file name
| Is This Answer Correct ? | 8 Yes | 0 No |
Answer / arjun
if we want to delete the dataset file completely we have to delete the 3 dataset files
1.Descriptor file
2.Data file
3.Control File
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / chandrakant swain (hara)
suppose we have one file HSBC.ds ,having 5 fields or
columns,and
20 records,for deleting the all record
then
>$head -1 HSBC.ds > NEW_HSBC.ds
then rename the new file use mv command ,like this mannaer
>$mv NEW_HSBC.ds HSBC.ds
| Is This Answer Correct ? | 3 Yes | 18 No |
How do you schedule or monitoring the job?
How do you reject records in a transformer?
Explain briefly scd type2 in datastage7.5x2(parallel)
how can u connect the client system directly at any time?
Can you explain kafka connector?
What is the difference b/w Hash file and Lookup Fileset stages?
Have you used Unstructured data?
How to convert alpha Numeric values to alpha using functions?
What is RCP
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.
What is the difference between server job and parallel jobs?
A flatfile contains 200 records.I want to load first 50 records at first time running the job,second 50 records at second time running and so on,how u can develop the job?pls give the steps?
Teradata 
