How to delete the data in dataset?types of deleting the data
in dataset?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between server job and parallel jobs?

920


Enlist various types of routines in datastage.

897


1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do

1895


file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4

725


Define APT_CONFIG in Datastage?

861


What are the important features of datastage?

840


Differentiate between data file and descriptor file?

815


Differentiate between validated and Compiled in the Datastage?

919


What could be a data source system?

767


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.

3769


tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise

2934


How do you start developing a datastage project?

861


Notification Activity

1176


What is orabulk stage?

841


Name the different sorting methods in datastage.

820