Answer / danny archer

we can view the log of a job in datastage director. for
example you are in datastge designer window and you are
running the job. Now goto tools menu and click "run
director". Now you can see datastage director, click the
log button on the tool bar. Here you could view log of your
job.

Answer / bond

YOU CAN REFFER FROM THE DATASTAGE DIRECTORY OR EACH JOB
WILL CREATE LOG FILE AND STORED IN REPOSITARY.

Answer / rajesh reddy

Log you can find this in DataStage Director,It can show
Errors and Warnings for a particular job.

Tools>Run Director>log

Answer / poorna chandra

Hi this is Poorna Chandra,

For any job, we can vew log file through DataStage
Director or Through using Unix Command .

If we want to view the log file in Director this is the
approach that you have to follow .
Go To DataStage Director , Select the Job and right CLICK
then it will open one list there select log file
or
By selecting Job and by clicking job log icon we can see
the job log file .


This are the approaches to see the log file in
Director ,but through this method you can not see the
complete log file list ,If you want to see the complete
list Better use UNIX command to see the log file .

Answer / ramesh

view log means if job is fail inthat time see the view log find the errows.

Answer / kiran

what is the difference between lookup and join

if a column contains data like ram,rakesh,madhan,suraj,pradeep,bhaskar then I want to place names separated by commas in another columns how can we do?

5 Answers  

how to load meta data

2 Answers   IBM,

Tell me the syntax of Configuration file?

1 Answers  

How to exclude first and last lines while reading data into a sequential file(having some 1000 records).I guess probably by using unix filter option but not sure which to use

6 Answers   IBM,

i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu

0 Answers  

A flat file contains 200 records. I want to load first 50 records at first time running the job, second 50 records at second time running and so on, how u can develop this job?

1 Answers   TCS,

Source Like department_no, employee_name ---------------------------- 20, R 10, A 10, D 20, P 10, B 10, C 20, Q 20, S and Output should be like this department_no, employee_list -------------------------------- 10, A 10, A,B 10, A,B,C 10, A,B,C,D 20, A,B,C,D,P 20, A,B,C,D,P,Q 20, A,B,C,D,P,Q,R 20, A,B,C,D,P,Q,R,S

3 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  

Triggers,VIEW,Procedures

0 Answers   CTS,

How can we improve the performance in datastage?

0 Answers  

source has 2 fields like COMPANY LOCATION IBM HYD TCS BAN IBM CHE HCL HYD TCS CHE IBM BAN HCL BAN HCL CHE LIKE THIS....... AND I WILL GET THE OUTPUT LIKE THIS.... Company loc count TCS HYD 3 BAN CHE IBM HYD 3 BAN CHE HCL HYD 3 BAN CHE PLZ SEND ME ANSWER FOR THIS QUESTION..........

3 Answers   Patni,

What are sequencers?

0 Answers