Answer / dnm12345

APT_DUMP_SCORE is an reporting environment variable , used to show how the data is processing and processes are combining

Answer / mamatha

APT_DUMP_SCORE provide details in the log output on how the framework partition the datasets, and the processes/partitioning that the operator are taking up.

This information is useful when you wish to observe the partitioning process of your job, and identifying potential bottlenecks on your job flow (especially tasks that are inserted by default by the framework).

If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?

0 Answers  

---

How a routine is called in datastage job?

0 Answers  

---

This is UNIX question asked in DataStage Interview. Say I have n numbers of records in a text file. I want first 3 records in 1st file, last three records in 3rd file and remaining n-6 records in 2nd file. (Note: we don't know how many records are there in the File. I am getting one file on daily basis and I want three target files as asked above)

2 Answers   CTS,

---

How do u view log file for a particular job?

6 Answers   HP,

---

What is the importance of the exception activity in datastage?

0 Answers  

---

---

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

0 Answers   NTT Data,

---

Hi I am Vijay In my source i've 10 records in a single column.... but i want to split those records into 5 sequential files each seq file contains 2 records.?.... can any body help me?

15 Answers   Scope International,

---

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 3 diffrent tables. 1) US rate data 2)CANADA rate data and 3)MEXICO rate data. All 3 tables have 6 collumns each. 4 collumns are commun to all tables and 2 are diffrent. Now at target i want single table say Country rate which will have (4+2+2+2+1 flag) 11 collumns. I will add a flag collumn which will indicate country and will put nullable collumns which are not common to other. How i can implement this in datastage?

1 Answers   ABC,

---

Define Data Stage?

0 Answers  

---

What's the Main Function of the Staging area in DWH

3 Answers   Oracle,

---

if a column contains data like abc,aaa,xyz,pwe,xok,abc,xyz,abc,pwe,abc,pwe,xok,xyz,xxx,abc, roy,pwe,aaa,xxx,xyz,roy,xok.... how to send the unique data to one source and remaining data to another source????

3 Answers  

---