How to delete the data in dataset?types of deleting the data
in dataset?
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 |
Hi all, explain one complex business rule that you had in your project and how did you accomplish it using DS?
in oracle target stage when we use load option and when we use upsert option?
There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this
what is the custome stage in datastage? how can we impliment that one? plz tell me
What is the use of datastage director?
How to reverse the string using SQL?
can we use sequential file as a lookup
where the log files or tables can store in DS?
how to find out number of records imported into source file?
how to create document in datastage?
If I make any changes in the parallel job,do I need to implement the changes in the sequencer job,else the changes will be reflected automatically
What is the project in datastage?