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


Please Help Members By Posting Answers For Below Questions

Differentiate between data file and descriptor file?

678


Define ds designer?

843


How do you run datastage job from the command line?

676


Which commands are used to import and export the datastage jobs?

1060


Define Merge?

956






What are the types of containers?

773


CHANGE CAPTURE

956


Distinguish between informatica & datastage. Which one would you choose and why?

649


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?

1103


What is datastage engine?

795


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

3392


Differentiate between odbc and drs stage?

668


Why fact table is in normal form?

750


in oracle target stage when we use load option and when we use upsert option?

1829


What is the difference between orabulk and bcp stages?

657