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
How do you generate sequence number in datastage?
On which Dimension Table you implemented SCD Type in your Project
What is the difference between informatica and datastage?
What are the job parameters?
What are the components of ascential data stage?
What is the project in datastage?
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
which r the connectors used in san?
In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?
What is difference between symmetric multiprocessing and massive parallel processing?
Distinguish between informatica & datastage. Which one would you choose and why?
Differentiate between datastage and datastage tx?
What is ds designer?
What are the different options associated with dsjob command?
What are the main features of datastage?
