Answer Posted / sagar
When you use sequential file as Source,at the time of
compilation it will convert to native format from
ASCII.where as,when you go for using datasets... conversion
is not required.Also, by default sequenctila files we be
processed in sequenc only.sequential files can accommodate
up to 2GB only.sequentila files does not support NULL
values....all the above can me overcome using dataset
stage....but selection is depeneds on the
requirement....suppose if you want to capture rejected
data....in that case you need to use sequential file or
fileset stage....
Is This Answer Correct ? | 22 Yes | 4 No |
Post New Answer View All Answers
Can we use target hash file as a lookup ?
what is the use of surogate key in datastage
What is datastage engine?
Can you filter data in hashed file?
what is the use of skid in reporting?
How to reverse the string using unix?
Difference between in process and inter process?
Can you explain players in datastage?
Describe the architecture of datastage?
how many rows sorted in sort stage by default in server jobs
what is repositery?
How to reverse the string using SQL?
8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?
Differentiate between odbc and drs stage?
for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr