what is the exact difference between dataset and fileset in
datastage?
Answer Posted / lokesh butra
Dataset operate the file local server and also its support
upto 2 GB Data
File set operates the file local and remote servers and
also its support unlimited Data
| Is This Answer Correct ? | 2 Yes | 7 No |
Post New Answer View All Answers
how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.
What are the enhancements made in datastage 7.5 compare with 7.0?
Is it possible to query a hash file?
Explain how a source file is populated?
What is difference between symmetric multiprocessing and massive parallel processing?
What is the difference between hashfile and sequential file?
What is the difference between informatica and datastage?
how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara
Explain the datastage parallel extender (px) or enterprise edition (ee)?
What are iconv and oconv?
Define orabulk and bcp stages?
What is ibm datastage?
how to delete one row in target dataset
what is the use of surogate key in datastage