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

I am defining one varaible parameter date in job parameters.I want use this variable date in where clause in source query.

2 Answers   TCS,

What is aggtorec restructure operator?

0 Answers  

Which type of joins Merge stage can support?

7 Answers   IBM,

IS IT POSSIBLE TO USE DATASET AS A SOURCE FILE?

3 Answers   Infosys,

what is the differeces between hash and modulus partition methods

4 Answers   TCS,

i have one table with one column in this column i have three rows like 1,1,2 then that rows populate to target as first tow rows as one row and remaing row as one row how it posible? COLUMN_NAME SHIVA RAMU MADHU THEN I WANT TO LIKE SHIVA AND RAMU IN ONE ROW AND MADHU IS ONE ROW IF ANY ONE KNOW PLZ TELL ME

3 Answers   Cap Gemini,

A table containg 100 records B table containg 20 records we have to join two tables in left outer it containg target 100 records but target containg 101 record at that time what is the issue arise

3 Answers   Polaris,

source file having the data like aabbccc, i want target file result like a1a2b1b2c1c2c3.

2 Answers  

what is the Difference Between Datastage Server Edition and Parallel Edition?

2 Answers   Tech Mahindra,

Can you explain players in datastage?

0 Answers  

Which warehouse using in your datawarehouse

0 Answers   IBM,

How can we achive parallelism

1 Answers   CTS,