why dataset ?
Answers were Sorted based on User's Feedback
Answer / srinivas
Dataset is a file which can be used for stored data as intermediate result.
Compared to other files processing is fast by using the Dataset because its internal format is DataStage support format.
Most of the times we can use this as intermediate data storage.
One added advantage is node system we can use multiple nodes
in dataset.
We have lot of uses by using this file dataset.
In server edition we have hashfile same way in parllel edition we will use DataSet.
| Is This Answer Correct ? | 1 Yes | 0 No |
Emp login_timestamp Logout_timestamp A,2019-02-01 02:24:15,2019-02-01 04:59:42 B,2019-03-29 14:43:30,2019-03-29 20:22:00 ABC,2019-03-29 12:43:00,2019-03-29 23:22:59 In the above calculate the duration of hours spent in office for each emp in datastage.
Define repository tables in datastage?
In Datastage, how you can fix the truncated data error?
what are the errors,warnings in datastage
What is the use of Row generator stage?
how to sort two columns in single job in datastage.
how can u handle null values in transformer stage.
Hi guys, In sequencer job, we have 3 sources, in that 1st source have some records, Here requirement is 1st source records are 100 then only run the job otherwise total job will abort... How to calculate this. please design the job. Thanks.
What is the use of datastage director?
In Sequential file, how can i split a column into two, and that column contains string datatype. For Example, i have column of string datatype as subedar khaja. Now i want get output as separately with subedar in one column and khaja in second column. How? Coula anybody, solve it?
what is combinability and non combinability?
Hi All, I have a file. i need to fetch the records between first and last records by using transform stage. EX:- Source: EMPNO EMPNAME 4567 shree 6999 Ram 3265 Venkat 2655 Abhi 3665 Vamsi 5852 Amit 3256 Sagar 3265 Vishnu Target: EMPNO EMPNAME 6999 Ram 3265 Venkat 2655 Abhi 3665 Vamsi 5852 Amit 3256 Sagar I dont wan't to Shree and vishnu records.we can fetch another way also but How can I write the function in transform stage?