A job is having only 2 stages I/p dataset and target table.Job is taking very long time to load 50 million records.How to improve performance of this job.

3 Answers   IBM,

---

hi, 1)totally how many jobs created in ur project 2)what is ur datamart size & Dwh size 3)How secure ur project 4)could u plz tell be about testing process after complete the job will run sucessfully or not in Datastage

1 Answers   Wipro,

---

How a source file is populated?

0 Answers  

---

How to remove duplicates in transformer stage? in parallel mode

6 Answers   Syntel, TCS,

---

Can we use Round Robin for aggregator?is there any benefit underlying?

3 Answers   TCS,

---

how many datamarts we will use in real time project and when will use the datamart?pls send the replay early

2 Answers   Tech Mahindra,

---

specify data stage strength?

1 Answers  

---

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  

---

HOW CAN U DO ERROR HANDLING IN DATA STAGE?

8 Answers   ME,

---

my soure table is emp having columns sal,deptno in the deptno 10,20,30deptno row are there expected out put is min(sal) of 10th deptno,max(sal) of 20th deptno,mean(sal) of 30th deptno using aggregation stage

4 Answers  

---

I have 5 different sources i want same records in 5 different targets Can you any body send me this question answer rathdsetl@gmail.com

2 Answers   TCS,

---

i want anser this question empno,ename,sal 12,mmm_ww,200 13,nnn_xx,300 14,bbb_qq,400 which stages are take which types of logicks are doing pls help me

0 Answers  

---