Interested to Buy Any Domain ? << Click Here >> for more details...
HOW CAN WE SEE THE DATA IN DATASET?
- 12 Answers
- 58526 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 |
I am running a job with 1000 records.. If the job gots aborted after loading 400 records into target... In this case i want to load the records in the target with 401 record... How will we do it??? This scenario is not for sequence job it's only in the job Ex: Seq file--> Trans--> Dataset..
9 Answers Cognizant, IBM, TCS, Virtusa,
for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr
There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this
What is the use of datastage director?
How a server job can be converted to a parallel job?
I want capture UnMatched records from Primary source and secondary source in JOIN stage?
What is APT_DUMP_SCORE?
Please Tell me..,I need some Complex Jobs in datastage as per in interview?how to tell and how to explain?please send as well as posiible please
i have source like deptno,sal 1,2000 2,3000 3,4000 1,2300 4,5000 5,1100 i want target like target1 deptno,sal 1,2000 3,4000 4,5000 target2 2,3000 1,2300 5,1100 with out using transformerstage
1.What is a delta record? How you will read it? 2.What are the different types of sorting?
how can we create tables in datastage?
How do you import and export data into datastage?
Teradata 
