Answer / pavan

In the designer, tools->Dataset Management-> Browse for the
dataset you want to view-> A window with the nodes on which
the dataset is distributed gets displayed-> Select one of
the nodes and Click on "Show Data Window" option that
appears on the top left section of the window. By doing
this one gets to know the data on each node.

Answer / ankur

1 ) By View Data

2) By Unix - But the data will be unformatted as dataset
data is distributed over several nodes.

Answer / madhu

we can see the data in data set by using DATA SET MANAGEMENT utility in designer,director and manager
OR
Data stage provide one UNIX utility to manage the data set in UNIX environment. ORCHADMIN..
Using this utility we can see the data in dataset.

Answer / seshu

orchadmin dump -name <dataset name> >> <fileset name>

Answer / metilda

We cannot see the data in the Data Set (.ds files) through
Unix, Editplus etc.
1. But we can view the data by connecting a Peek stage to
the Data Set stage in a job. Go to Director--> job name ---
> Peek stage (view .ds file data) or
2. Connect Sequential File Stage as the target stage to the
Data Set stage. In the Sequential File Stage-->Input Tab--
>Properties--> Give the Target file path. For Eg:
(/local/data1/edw/temp/DataSetOp.txt) and run the job. the
new text file gets loaded with data from the .ds file. Thus
data will be in a readable format in the text file.

Answer / vinod upputuri

Gentlemen, We can view the data in dataset in unix by using
orchadmin command
syntax: orchadmin dump <descriptor.ds>

copy the contents of dataset into flat file:

Syntax: orchadmin copy <descriptor_file.ds> <flatfile>

count of records:

Syntax: orchadmin copy <descriptor_file.ds> <flatfile> | wc -l

Answer / archana

In the designer, tools->Dataset Management-> Browse for the
dataset you want to view-> A window with the nodes on which
the dataset is distributed gets displayed-> Select one of
the nodes and Click on "Show Data Window" option that
appears on the top left section of the window. By doing
this one gets to know the data on each node.

Answer / ranjan

we can't see data to unix consoles,we can only delete by
orchadmin command.

Answer / prasu

Hi pavan,
By using this we cannot see the data in the actual format...
right?Please corrcet me if I am wrong..

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

how to export or import the jobs in .ISX file

0 Answers  

2.how u run your rotines in unix? what is job sequencer? if i have 4 jobs i would like to run 2 jobs in server(using job jobsequencer)and remaining 2 in parallel?how can i run?

1 Answers  

What is a range lookup?

2 Answers   IBM,

HOW WILL YOU IMPLEMENT SURROGATE KEY IN SCD BY USING SURR_KEY GENERATOR,THE VALUE OF S_KEY SHOULD NOT REPEAT EVEN IF THE JOB IS COMPILED REPEATEDELY?

4 Answers   L&T,

What is the project in datastage?

0 Answers  

Hi dude, i/p eno ename date edate deptno 1 x 10thjuly 30july A 2 y 10th aug 30 aug B 1 x 1aug ------ A 3 z 1jan ------ c 2 y 1sep ------ B o/p is eno ename date edate deptno 1 x 1aug ------ A 2 y 1sep ------ B 3 z 1jan ------ c Here edate is System generates we don't know that value. Please design the job by using SCD stage and Sql query. If any body know this answer please tel me. Tanks.

1 Answers   Amdocs,

how can u connect the client system directly at any time?

1 Answers   IBM,

Describe link sort?

0 Answers  

Please explain me the difference between 3 types of slowly changing dimension in datawarehousing?

3 Answers   TCS,

What are the various kinds of containers available in datastage?

0 Answers  

what is the custome stage in datastage? how can we impliment that one? plz tell me

0 Answers   Accenture,

Pls tell me what is troubleshooting in datastage view?

1 Answers