HOW CAN WE SEE THE DATA IN DATASET?
Answers were Sorted based on User's Feedback
Answer / metilda
We cannot see the data in the Data Set (.ds files) through
Unix, Editplus etc. 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)
| Is This Answer Correct ? | 4 Yes | 8 No |
Answer / balaji
right click on the data set and select by view data option
| Is This Answer Correct ? | 1 Yes | 15 No |
what is the difference between INROWNUM AND OUTROWNUM IN DATASTAGE SERVER EDITION?
I have 2 files 1st contains duplicate records only, 2nd file contains Unique records.EX: File1: 1 subhash 10000 1 subhash 10000 2 raju 20000 2 raju 20000 3 chandra 30000 3 chandra 30000 File2: 1 subhash 10000 5 pawan 15000 7 reddy 25000 3 chandra 30000 Output file:-- capture all the duplicates in both file with count. 1 subhash 10000 3 1 subhash 10000 3 1 subhash 10000 3 2 raju 20000 2 2 raju 20000 2 3 chandra 30000 3 3 chandra 30000 3 3 chandra 30000 3
How to generate surrogate key without using surrogate key stage?
Difference between ‘validated ok’ and ‘compiled’ in data stage?
how to change left and right links in join stage?
Hi Vijay here For Four CPU's how many nodes will required?
is it possible to access the same job by two users at a time in DataStage?
table actions available in oracle connector?
What are stage variables?
Is it possible to query a hash file?
What is the function in Transformer stage can act as Rank Function in oracle
what is advantages of snowflake when it is used?