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
- 24630 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 |
Difference in the implementation of lookup and join stages,in joining two tables?
Can we use sequential file as source to hash file? Have you do it ?if what error it will give?
country, state 2 tables r there. in table 1 have cid,cname table2 have sid,sname,cid. i want based on cid which country's having more than 25 states i want to display?
source which format u will get either fixed or delimiter length format? what is the symbol of delimiter?
What are the components of ascential data stage?
How and where you used hash file?
Differentiate between validated and Compiled in the Datastage?
How can we do null handling in sequential files?
hi i am madan, in real time data stage who is the source provide? and how to recevied in developer? Pls send me answer
Hi dude, i/p eno ename date edate deptno 1 x 10thjuly 30july A 2 y 10th aug 30 aug B 1 x 1aug ------ A 3 z 1jan ------ c 2 y 1sep ------ B o/p is eno ename date edate deptno 1 x 1aug ------ A 2 y 1sep ------ B 3 z 1jan ------ c Here edate is System generates we don't know that value. Please design the job by using SCD stage and Sql query. If any body know this answer please tel me. Tanks.
if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables?chandu how can i implement scd typ1 and type2 in both server and in parallel?chandu field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the ,inthe fields?
Define ds designer?
Teradata 
