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

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

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

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

What are stage variables, derivations and constants?

0 Answers  

---

What a datastage macro?

0 Answers  

---

there are indexes on a table as index1 with col1, col2 index2 with col2 index3 with col1,col2,col3. if i run a query with col1='100' which index will be used and why

1 Answers   Virtusa,

---

Differentiate between odbc and drs stage?

0 Answers  

---

Can you explain engine tier in information server?

0 Answers  

---

i have a scenario with i/p as ID,salary with values 1,1000 2,2000 and 3,4000 i need an extra column in the o/p named amount with values 2000,4000 and NULL. how can i get it?

2 Answers   L&T,

---

what are fact tables and dimension tables? give example assuming one table.

3 Answers   IBM,

---

if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?

1 Answers   IBM,

---

which unix commands mostly used in datastage

3 Answers   HSBC,

---

What are stage variables?

0 Answers  

---

Explain Quality stage?

0 Answers  

---

how can we create a Sorrogate key in transformer stage? I want it in parallel mode

2 Answers   Syntel,

---