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 is data partitioning?
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.
Differentiate between odbc and drs stage?
What are stage variables?
Name the different sorting methods in datastage.
How a routine is called in datastage job?
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
Which algorithm you used for your hashfile?
On which Dimension Table you implemented SCD Type in your Project
Explain entity, attribute and relationship in datastage?
What is the difference between datastage and datastage tx?
Differentiate between operational datastage (ods) and data warehouse?
what is ds administrator used for?
How one source columns or rows to be loaded in to two different tables?
what is repositery?