1)What is configuration your file structure
2)I have two databases both are Oracle while loading data
from source to target the job takes 30 min but I want to
load less time how?



1)What is configuration your file structure 2)I have two databases both are Oracle while loading da..

Answer / suren

delete the indexes while loading into database.

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Data Stage Interview Questions

what is use of SDR function?

0 Answers   CGI,


what is data mapping

2 Answers  


How do u convert the columns to rows in datastage?

0 Answers  


How to convert table data into xml file using xml output stage? please explain step by step;

2 Answers   IBM,


parallel jobs run on cluster machines. server jobs run on smp and mpp. What do mean by cluster mechines and SMP and MPP..?

3 Answers  


In Datastage, how you can fix the truncated data error?

0 Answers  


In a table 100 records are there after 50records job is aborted how can u insert all records in target table.

1 Answers   Cap Gemini,


on how many columns we can perform aggregation in the aggregator stage?

2 Answers   Reliance,


Whats difference betweeen operational data stage (ods) and data warehouse?

0 Answers  


what is the difference between the join and look up explin me one exmple

3 Answers  


I want capture UnMatched records from Primary source and secondary source in JOIN stage?

3 Answers   TCS,


How to create user defined environment varibale(parameter)?

1 Answers   TCS,


Categories