Interested to Buy Any Domain ? << Click Here >> for more details...
HOW CAN WE SEE THE DATA IN DATASET?
- 12 Answers
- 59030 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 |
tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise
Can you explain engine tier in information server?
What is a quality stage?
What are the enhancements made in datastage 7.5 compare with 7.0?
What is meta stage?
Anyone has Datastage certification free dumps for 000-418 , 000-421 codes, mail me @ manik.dwh@gmail.com 000-418 : InfoSphere DataStage v8.0 000-421 : InfoSphere DataStage v8.5
Can we use target hash file as a lookup ?
there are two schemas x and y are there. some data is in x schema. i want to use that in y schema..how can i use? please give some possibilities
WHAT are unix quentios in datastage
CAN WE DECLARE DATASET SET WITH OTHER THAN .DS EXTENTION OR NOT IF YES WHAT IS THE DIFFERENCE U FIND?IF NOT WHY?
what is difference between migration project and integration project? can anyone explain with the example Thanks in advance
I have a source like file it have Number of records and i want to load without first and last records in target?Datastage?
Teradata 
