Answer Posted / subhash

Syntax:
Orchadmin delete | del | rm [options] dataset_Name1 …
sataset_NameN
EX:
a. Orchadmin delete EMP1.ds EMP2.ds EMP3.ds
b. Orchadmin rm EMP*.ds

Is the value of staging variable stored temporarily or permanently?

587

---

How complex jobs are implemented in datstage to improve performance?

604

---

Can you explain tagbatch restructure operator?

707

---

how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)

532

---

In Datastage, how you can fix the truncated data error?

648

---

---

What is aggtorec restructure operator?

739

---

What are constraints and derivations?

662

---

Can we use target hash file as a lookup ?

2822

---

i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS

3324

---

What are the various kinds of containers available in datastage?

571

---

what is use of SDR function?

4716

---

What is the difference between passive stage and active stage?

832

---

Explain the situation where you have applied SCD in your project?

1568

---

How do you import and export the datastage jobs?

741

---

What are routines in datastage? Enlist various types of routines.

636

---