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
- 24665 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 |
guys pls tell me where we use sequence jobs exactly in realtime proj explain pls with example.
Explain the ChangeApply stage?
What are the environmental settings for data stage,while working on parellel jobs?
col1 123 abc 234 def jkl 768 opq 567 789 but i want two targetss target1 contains only numeric values and target2 contains only alphabet values like trg1 123 234 768 567 789 trg2 abc def jkl opq
What is merge stage?
what is the difference between 7.1,7.5.2,8.1 versions in datastage?
when will you go for dataset and fileset?
How can we improve performance of data stage jobs?
How to lode data in sequntional files perform faster?
What are the repository tables in datastage?
Can we use target hash file as a lookup ?
my source seq file have col1 1 2 3 4 5 6 7 8 9 i have 4 targets t1 t2 t3 t4 1 2 3 4 5 6 7 8 9 like this how we can get?
Teradata 
