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
how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara
Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC
tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise
How can you write parallel routines in datastage PX?
Define Data Stage?
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
What is the difference between server job and parallel jobs?
i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS
What is datastage?
What are orabulk and bcp stages?
Can you explain tagbatch restructure operator?
Define APT_CONFIG in Datastage?
Explain how a source file is populated?
How complex jobs are implemented in datstage to improve performance?
im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination