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

What is ibm datastage flow designer?

1131

---

How can one find bugs in job sequence?

1371

---

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

2024

---

What are the features of datastage flow designer?

1029

---

if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?

2169

---

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

2077

---

Explain ibm infosphere information server and highlight its main features?

1082

---

Distinguish between informatica & datastage. Which one would you choose and why?

996

---

How a source file is populated?

1050

---

Can you explain engine tier in information server?

1112

---

What is the use of hoursfromtime() function in transformer stage in datastage?

1050

---

Differentiate between datastage and datastage tx?

1041

---

What is the difference between odbc and drs stage?

1080

---

What are sequencers?

1095

---

how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara

789

---