IS IT POSSIBLE TO USE DATASET AS A SOURCE FILE?
Answers were Sorted based on User's Feedback
Answer / arshad basha
Initially we cannot use the dataset as a source.cause it is an internal format creation of datastage. if the source file is in the format of flat file means then we select sequential file as a source and dataset as a target.After this creation we use the target as a source for the next step. .ds is the file extension of dataset.
| Is This Answer Correct ? | 27 Yes | 0 No |
Answer / dilip anand k.
Nope. Dataset can never be used as a primary source or a
final target. It can be used only as an intermediate storage
or intermediate source and a target. This is because,
Dataset is something that is proprietary to Data stage and
is understandable only to Data stage engine and none other.
| Is This Answer Correct ? | 4 Yes | 6 No |
How can we read latest records in a text file named file1.txt using seq file stage only? file1 having 100 records in that 5 record sare latest records.How can we read that latest records?
Hi frnds, my scenario is like i'm having a record 1234"1323£3434%343434^23232!1212$23232 in the above record all the special characters must be removed.how can we do it in datastage 8.0.1.can any one please ans this? thanx in advance
What is the use of hoursfromtime() function in transformer stage in datastage?
How can we improve performance of data stage jobs?
Unix command to view the data in a dataset
How to convert alpha Numeric values to alpha using functions?
Name the command line functions to import and export the DS jobs?
What is data partitioning?
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
Highlight the main features of datastage?
Hi, I am getting data from sequential file like below column1 A&B C&D A&E X&Y&Z v&x But I need the target column as like below column1 A and B C and D A and E X and Y and Z v and x
If there is a file that contains 1000 records, I need the ouput to contain these 1000 records with the header as file name concatenated with the current timestamp and trailer as the count of records