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 complex jobs are implemented in datstage to improve performance?
What is the difference between informatica and datastage?
How to reverse the string using unix?
Can you explain kafka connector?
Where the datastage stored his repository?
Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?
Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance
How can you write parallel routines in datastage PX?
Explain Quality stage?
What is ibm datastage?
What are routines in datastage? Enlist various types of routines.
what is the difference between == and eq in UNIX shell scripting?
What is a merge?
What are the different kinds of views available in a datastage director?
Can you explain engine tier in information server?