Interested to Buy Any Domain ? << Click Here >> for more details...
HOW CAN WE SEE THE DATA IN DATASET?
- 12 Answers
- 58123 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 |
1.what is materialized data? 2.how to view the materialized data?
DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks
What are the differences between datastage and informatica?
HOW CAN WE SEE THE DATA IN DATASET?
how can or from where we can get reference data in scd type2 implementation?
why we use parameters instead of hard code in datastage
what are the devoleper roles in real time? plz tell i am new to datastage....
How to remove blank spaces from data?
What is a quality stage?
in sequtial file 2 columns avaliable, i want only one column load the target. for this we can do by modify and copy stage. But here when using modify stage (in property drop column1) until it is ok. if target is data set How to view the data. with out using data management. what is the reason for this. if any body know this answer plz tel me. thanks.
CHANGE CAPTURE
if a column contains data like ram,rakesh,madhan,suraj,pradeep,bhaskar then I want to place names separated by commas in another columns how can we do?
Teradata 
