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?

Answer Posted / suren

delete the indexes while loading into database.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance

1965


AGGREGATOR default datatype

1141


What are the stages in datastage?

828


How will you move hashed file from one location to another location?

1890


8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?

2011


What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?

1866


root tree will find which is server job and which is parallel job?

1639


Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2

544


What are the different kinds of views available in a datastage director?

793


How do you schedule or monitoring the job?

874


Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also

2964


Can you explain players in datastage?

952


how to export or import the jobs in .ISX file

947


how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)

704


What are the types of hashed files in data stage

864