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 meta stage?
What is a merge?
How do you reject records in a transformer?
State the difference between an operational datastage and a data warehouse?
Differentiate between hash file and sequential file?
Difference between data warehousing and olap?
Explain ibm infosphere information server and highlight its main features?
What is the command line function to import and export the ds jobs?
What are stage variables and constants?
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
Define Merge?
How to implement complex jobs in data stage?
Define repository tables in datastage?
what is 'reconsideration error' and how can i respond to this error and how to debug this
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
