IS IT POSSIBLE TO USE DATASET AS A SOURCE FILE?
- 3 Answers
- 13279 Views
- Infosys, I also Faced
- E-Mail Answers
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 |
Hi friends,Two input files, wants to validate only if the reference data has '0' otherwise no validation should be done..how to do this??
Unix command to view the data in a dataset
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?
What is the difference between informatica and datastage?
I/P --- ID Value 1 AB 2 ABC 3 ADE 4 A O/p --- ID Value 1 A 1 B 2 A 2 B 2 C 3 A 3 D 3 E 4 A
What are constraints and derivations?
How to exclude first and last lines while reading data into a sequential file(having some 1000 records).I guess probably by using unix filter option but not sure which to use
Why do we use exception activity in Datastage?
i have a small question for datastage, After the desinging (i.e., transformations and loading)part, what we can do?
What is the surrogate key? what is the use of surrogate key? how to Create surrogate key Generator in scd2 in 8.5?
What are some prerequisites for datastage?
where we use column generator stage in real time scenario?
Teradata 
