HOW CAN WE SEE THE DATA IN DATASET?
- 12 Answers
- 54217 Views
- IBM, TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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.
| Is This Answer Correct ? | 23 Yes | 1 No |
Answer / ankur
1 ) By View Data
2) By Unix - But the data will be unformatted as dataset
data is distributed over several nodes.
| Is This Answer Correct ? | 18 Yes | 6 No |
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.
| Is This Answer Correct ? | 8 Yes | 1 No |
Answer / seshu
orchadmin dump -name <dataset name> >> <fileset name>
| Is This Answer Correct ? | 4 Yes | 0 No |
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.
| Is This Answer Correct ? | 6 Yes | 3 No |
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
| Is This Answer Correct ? | 6 Yes | 4 No |
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.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / ranjan
we can't see data to unix consoles,we can only delete by
orchadmin command.
| Is This Answer Correct ? | 7 Yes | 6 No |
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
| Is This Answer Correct ? | 2 Yes | 4 No |
How to perform incremental load in datastage?
what is the difference between INROWNUM AND OUTROWNUM IN DATASTAGE SERVER EDITION?
on how many columns we can perform aggregation in the aggregator stage?
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
col1 123 abc 234 def jkl 768 opq 567 789 but i want two targetss target1 contains only numeric values and target2 contains only alphabet values like trg1 123 234 768 567 789 trg2 abc def jkl opq
how to get the unique records on multiple columns by using sequential file stage only
Hi, I have 3 records, 1 Srini 1 vasa 2 reddy now i want o/p like this 1 Srinivasa 2 reddy could u please help in this Thanks in advance.
How to convert alpha Numeric values to alpha using functions?
Emp login_timestamp Logout_timestamp A,2019-02-01 02:24:15,2019-02-01 04:59:42 B,2019-03-29 14:43:30,2019-03-29 20:22:00 ABC,2019-03-29 12:43:00,2019-03-29 23:22:59 In the above calculate the duration of hours spent in office for each emp in datastage.
can any one tell me how to install datastage 8.1 in windows xp with wizard
Differentiate between hash file and sequential file?
What is the use of hoursfromtime() function in transformer stage in datastage?
Teradata 
