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
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
AGGREGATOR default datatype
What are the stages in datastage?
How will you move hashed file from one location to another location?
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?
What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?
root tree will find which is server job and which is parallel job?
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
What are the different kinds of views available in a datastage director?
How do you schedule or monitoring the job?
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
Can you explain players in datastage?
how to export or import the jobs in .ISX file
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)
What are the types of hashed files in data stage