Answer Posted / vinod upputuri

Gentlemen, We can view the data in the Dataset in UNIX by
using orchadmin command.

syntax: orchadmin dump <datasetname>

we can also copy the content to flat file using copy command.

orchadmin copy <datasetname> <flat_fileName>

In order to count rows in Dataset:

orchadmin copy <datasetname> <flatfile> | wc -l

which r the connectors used in san?

2144

---

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

3701

---

What is the method of removing duplicates, without the remove duplicate stage?

965

---

Terminate Activity

1234

---

How to convert RGB Value to Hexadecimal values in datastage?

3929

---

what is ds administrator used for?

1113

---

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

3078

---

Can you define merge?

1066

---

Can you explain repository tables in datastage?

1342

---

What is the difference between an operational datastage and a data warehouse?

1092

---

im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination

2105

---

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)

869

---

What is a merge?

1078

---

Explain usage analysis in datastage?

1098

---

Which warehouse using in your datawarehouse

2117

---