Answer / kpk

DS Job Monitor is available in DS Director. Using this you
can monitor the DS job. that is u can get informations like
number rows that is being processed in each link or node,
how many stages, the flow of data ... etc...

Answer / hemachandra

If you want to know the particular job how many records are
processing/processed for each and every stage inside the
job then the job Monitoring will help you all the
information while running the job or after finishing the
job.
This function available in datastage director.

Answer / anil kumar.p

Hello...i just add the above answers
In above answers posted by Hemachandra,Kpk's are absolutely
currect

Job monitoring is a option in datastage director. Using this
we can monitor the job and we can get the Information abt
the job. i.e How many stages used for the corresponding
jobs,wt r the stages used, and how many records
process/processed in each link.

This Option "Job Monitoring" is available in datastage Director.

Not only that, we can see the records how they are going to
the different links. By this we come to judge weather the
records are going in a proper order to reach the Target.

Thanks....

Answer / nannesaheb

Hello...i just add the above answers
In above answers posted by Hemachandra,Kpk's are absolutely
currect




Job monitoring is a option in datastage director. Using this
we can monitor the job and we can get the Information abt
the job. i.e How many stages used for the corresponding
jobs,wt r the stages used, and how many records
process/processed in each link.

This Option "Job Monitoring" is available in datastage Director.



Thanks&Regards
-Nannesaheb(+918807423181)

Answer / hari chowdary

If you want to know the particular job how many records are
processing/processed for each and every stage inside the
job then the job Monitoring will help you all the
information while running the job or after finishing the
job.
This function available in datastage director.
the job monitoring is process is going on that job not
running in datastage same time

Answer / bharathd

Job monitoring is nothing but monitoring the loads in
Datastage and watch how the data extraction, Transformation
and loading is happening in the data stage server. This
task is done by operators. we can monitor the jobs through
Data stage Director.

i want for the 3rd max sal using for the any stage but max sal is based on the deptno ? any body know this ans pls send this mail siva3me@gmail.com

2 Answers   Wipro,

WHERE YOU USE UNIX COMMANDS AS A ETL DEVELOPER?

2 Answers   Wipro,

What are operators in datastage?

1 Answers  

I have the following columns in the EMP table Empid,Empname,Sal,month(Sal),year(Sal) and DOB(let us say the dob is 15th-Jan-1981) Desing a job such that the output contains the following empname,year(sal),tot(sal) and current age i.e. whether 18yrs or so on

1 Answers   Accenture,

Input file one has data as shown below 1 2 3 4 5 6 7 8 Input file two has data like 6 7 8 9 10 11 Design a data stage job which will provide me three output files as shown below: Output 1 6 7 8 Output 2 1 2 3 4 5 Output 3 9 10 11 Let me know your answers

4 Answers   IBM, PR3 Systems,

How can you write parallel routines in datastage PX?

0 Answers  

IN SEQUENTIAL FILE,I HAVE DATA LIKE THIS EID,ENAME 11,AA 11,CC 22,DD 33,EE 22,AA 22,BB 22,CC 11,BB THEN i SELECT perform sort ON eid,uncheck both unique,stable AND I CHOOSE hash SORTING.WHAT IS THE OUTPUT I CAN GET.what happend if i select UNIQUE,STABLE. PLEASE EXPLAIN HOW THE RECORDS DISPLAY AT TARGET.

1 Answers  

If seg file having 10 records ex:eid 1 2 " " 10 if oracle database having 100 records ex:eid 1 2 " " 100 how to delete matched records permenently from oracle database using datastage ?

5 Answers   Infotech,

In Sequential file, how can i split a column into two, and that column contains string datatype. For Example, i have column of string datatype as subedar khaja. Now i want get output as separately with subedar in one column and khaja in second column. How? Coula anybody, solve it?

2 Answers   Polaris,

what is the use of surogate key in datastage

3 Answers  

I have a input as: Col 1 1 2 2 3 I want 3 output as: Output1: 1 1 Output2: 2 2 Output3: 3 i.e. same duplicates should be in one target, other duplicate values should be in another target and so on.. Pls help

9 Answers   IBM,

I have 3 jobs A,B and C , which are dependent each other. I want to run A & C jobs daily and B job run only on sunday. how can we do it?

1 Answers   CGI,