HOW CAN WE SEE THE DATA IN DATASET?
- 12 Answers
- 53960 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 |
Can you highlight the main features of ibm infosphere information server?
tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise
Parallel job contains more than 20 stages. I want to find out which stage is more performance incentive.
if 3 table having different columes. like first table having 4 columns , second table having 3 columns and third table having 2 columns then how to capture the data by using funnel stage in parallel jobs...srinu.thadi
17 Answers IBM, TCS,
if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?
How much data u can get every day? 2)which data ur project contains? 3) what is the source in ur project?what is the biggest table & size in ur schema or in ur project?
What are stage variables, derivations and constants?
What is job control?
how many types of remove the duplicate records?
What are the different options associated with dsjob command?
I have 5 different sources i want same records in 5 different targets Can you any body send me this question answer rathdsetl@gmail.com
hi, how would i run job1 then job 3 , then job2 in a sequence of job1 ,job2,job3. Thanks sunitha
Teradata 
