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
Does datastage support slowly changing dimensions ?
Describe link sort?
Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.
What are stage variables and constants?
client know skid info?
What is the difference between datastage and datastage tx?
How to RD using transformer?
Define Routines and their types?
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?
What is difference between join, merge and lookup stage?
What is difference between symmetric multiprocessing and massive parallel processing?
Nls stands for what in datastage?
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys
what are the devoleper roles in real time? plz tell i am new to datastage....
What are iconv and oconv?