I have 100 records how can I load at a time from the single
time

Answer Posted / subhash

by setting/checking below in Target ORACLE Connector:
Record Count=2000 (default is 2000)
Array Size=2000 (default is 2000)
Write mode=Bulk Load

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to reverse the string using unix?

2777


how do u catch bad rows from OCI stage? And what CLI stands for?

2268


What is the purpose of pivot stage and types of containers in datastage

600


what are the devoleper roles in real time? plz tell i am new to datastage....

1626


what is use of SDR function?

4699






What is usage analysis in datastage?

795


Name the different sorting methods in datastage.

600


How we can covert server job to a parallel job?

583


what is the use of skid in reporting?

1943


What is the purpose of interprocessor stage in server jobs?

1713


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

3305


What are the difference types of stages?

610


How one source columns or rows to be loaded in to two different tables?

647


How many types of sorting methods are available in datastage?

616


Does datastage support slowly changing dimensions ?

649