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
What are the processing stages?
Is the value of staging variable stored temporarily or permanently?
What is the difference between in process and inter process?
What are orabulk and bcp stages?
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
How to implement complex jobs in data stage?
Describe routines in datastage? Enlist various types of routines.
Can you explain players in datastage?
What are some different alternative commands associated with "dsjob"?
Describe stream connector?
How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?
Describe link sort?
I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this
To see hidden files in LINIX?
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