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
Can you define merge?
What is orabulk stage?
How to manage date conversion in Datastage?
Is possible to create skid in dim,fact tables?
Describe stream connector?
What is the purpose of pivot stage and types of containers in datastage
what is repositery?
How to implement complex jobs in data stage?
What is apt_config in datastage?
What are the difference types of stages?
How the ipc stage work?
Explain ibm infosphere information server and highlight its main features?
AGGREGATOR default datatype
What are the different type of jobs in datastage?
Define APT_CONFIG in Datastage?