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
How a routine is called in datastage job?
How do you run datastage job from the command line?
Define meta stage?
What are the different types of lookups in datastage?
How and where you used hash file?
1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.
How do y read Sequential file from job control?
What is merge stage?
What is the precedence of stage variables,derivations, and constraints?
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?
Triggers,VIEW,Procedures
Can we use target hash file as a lookup ?
How do you generate sequence number in datastage?
What is the use of hoursfromtime() function in transformer stage in datastage?
tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise