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



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

Answer / 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

More Data Stage Interview Questions

source 1123445 I WANT OUTPUT AS DUPLICATES TO TARGET1 LIKE TARGET1 1144 NON-DUPLICATES TO TARGET2 TARGET2 235

6 Answers   US Technology,


How do you generate sequence number in datastage?

0 Answers  


i/p 1,a,1000 2,b,2000 3,c,3000 i want to get o/p as o/p 1,a,3000 2,b,4000 3,c,5000 how it can be done on using datastage?

5 Answers   HSBC,


CAN WE DECLARE DATASET SET WITH OTHER THAN .DS EXTENTION OR NOT IF YES WHAT IS THE DIFFERENCE U FIND?IF NOT WHY?

2 Answers  


Can you explain repository tables in datastage?

0 Answers  






Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?

0 Answers   IBM,


What is the difference b/w Hash file and Lookup Fileset stages?

1 Answers  


what is set mapping in datastage??

2 Answers   ADP,


where the log files or tables can store in DS?

2 Answers   IBM,


source contains 2 columns comes to target 4 columns how

1 Answers   IBM,


SOURCE CITY NAME1 NAME2 NAME3 NAME4 BGLR HCL CSC IBM TCS TARGET CITY COMPANY BGLR HCL BGLR CSC BGLR IBM BGLR TCS

1 Answers  


i have one table with one column in this column i have three rows like 1,1,2 then that rows populate to target as first tow rows as one row and remaing row as one row how it posible? COLUMN_NAME SHIVA RAMU MADHU THEN I WANT TO LIKE SHIVA AND RAMU IN ONE ROW AND MADHU IS ONE ROW IF ANY ONE KNOW PLZ TELL ME

3 Answers   Cap Gemini,


Categories