when we have to go for a sequential file stage & for a
dataset in datastage?
Answer Posted / srinu
when the memory limit requirement is more then we go for
dataset.because sequential file does not support more than
2gb memory limit
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Differentiate between data file and descriptor file?
Define ds designer?
How do you run datastage job from the command line?
Which commands are used to import and export the datastage jobs?
Define Merge?
What are the types of containers?
CHANGE CAPTURE
Distinguish between informatica & datastage. Which one would you choose and why?
In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?
What is datastage engine?
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
Differentiate between odbc and drs stage?
Why fact table is in normal form?
in oracle target stage when we use load option and when we use upsert option?
What is the difference between orabulk and bcp stages?