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


Please Help Members By Posting Answers For Below Questions

What is data partitioning?

747


1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.

3505


Differentiate between odbc and drs stage?

596


What are stage variables?

641


Name the different sorting methods in datastage.

617






How a routine is called in datastage job?

611


Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.

1624


Which algorithm you used for your hashfile?

695


On which Dimension Table you implemented SCD Type in your Project

1588


Explain entity, attribute and relationship in datastage?

637


What is the difference between datastage and datastage tx?

600


Differentiate between operational datastage (ods) and data warehouse?

678


what is ds administrator used for?

728


How one source columns or rows to be loaded in to two different tables?

668


what is repositery?

1301