Answer Posted / narayana
file set is nothing but collection of sequential files. if sourse database is greater than 2 GB than prefer to use file set.
Data set is internal stage in datastage.the extension of data set is .ds it never used to extract data from client location .it is used as intermediate stage between two tables.
Sequential : 1)it supports all formats like txt,csv,xls,etc.
2)it is used to extract data from flat files from client location.
Data set:1)it supports only .ds format
2)it will never extract data from flat files from client location.
| Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
What is the difference between account and directory options ?
Difference between in process and inter process?
How to reverse the string using unix?
What is use Array size in datastage
Difference between data warehousing and olap?
What is the command line function to import and export the ds jobs?
What is datastage engine?
What are iconv and oconv?
What is merge stage?
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
How rejected rows are managed in datastage?
why do u need the IOS upgradation in a FC switch
How to convert RGB Value to Hexadecimal values in datastage?
How and where you used hash file?
How many types of hash files are there?
