Interested to Buy Any Domain ? << Click Here >> for more details...
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 precedence of stage variables,derivations, and constraints?
What are the various kinds of the hash file?
How do you import and export the datastage jobs?
What are the repository tables in datastage?
What is the difference between account and directory options ?
How to clean the datastage repository?
1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do
What are routines in datastage? Enlist various types of routines.
What is size of a transaction and an array means in a datastage?
How do you import and export data into datastage?
Define meta stage?
Can you highlight the main features of ibm infosphere information server?
How will you move hashed file from one location to another location?
Whats difference betweeen operational data stage (ods) and data warehouse?
Define Data Stage?
