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

Hi friends, I am new to datastage, i have one query in datastage any one you please give reply to my post. I have a workbook (excel sheet) named as eg: xxxx, in that i have two tables emp(eid, ename, salary, deptno) and dep(deptno, name, state). in my source i have ODBC enterprise stage read the emp table and dept table join the two table and write the dept no 10(eid,ename,salary,name,state) values in target(). Thanks, Badari

0 Answers  


what is ds administrator used for?

0 Answers  


Emp login_timestamp Logout_timestamp A,2019-02-01 02:24:15,2019-02-01 04:59:42 B,2019-03-29 14:43:30,2019-03-29 20:22:00 ABC,2019-03-29 12:43:00,2019-03-29 23:22:59 In the above calculate the duration of hours spent in office for each emp in datastage.

1 Answers  


how can we send even and odd records from a sequential file to two different targets

10 Answers   IBM, iGate, TCS,


what is meant by port ? what is the use of port ? what are the different type of ports and its usage

2 Answers   Accenture,






I WANT TO SEND SYSDATE AS PARAMETER,SO WHAT COMMAND I SHOULD USE TO CALL SYSDATE?

4 Answers   ME,


What is datastage engine?

0 Answers  


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?

0 Answers  


we run a job in 4 nodes,i want to run same job on 8 nodes is it possible? job recompling is mandtory?why?

1 Answers   HSBC, NTT Data,


What r the existing server jobs in parallalism?

0 Answers   ITC Infotech,


what is materialized view used datastage?

1 Answers   HSBC,


What is quality stage?

0 Answers  


Categories