How to delete the data in dataset?types of deleting the data
in dataset?
Answer Posted / 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 |
Post New Answer View All Answers
What are stage variables and constants?
What is the use of datastage designer?
Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?
1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)
What are the different layers in the information server architecture?
What is the flow of loading data into fact & dimensional tables?
Define Job control?
how to abort the job its matain duplicates?
How to read the length of word in unix?
How do you run datastage job from the command line?
How do you import and export data into datastage?
What are the benefits of datastage?
What are the different options associated with dsjob command?
What is "fatal error/rdbms code 3996" error?
How we can covert server job to a parallel job?