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
Name the different types of Lookups in Datastage?
why do u need the IOS upgradation in a FC switch
How do you reject records in a transformer?
How and where you used hash file?
What all are the different way to run a job?
What are the functionalities of link partitioner?
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
What are the some differences between 7.x and 8.x version of datastage?
Define ds designer?
How many types of views are there in a datastage director?
file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4
What are the components of datastage?
What is the method of removing duplicates, without the remove duplicate stage?
Explain the importance of surrogate key in data warehousing?
what is 'reconsideration error' and how can i respond to this error and how to debug this
