Question { HP, 23161 }

How do u view log file for a particular job?

Answer

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 .

Question { HCL, 23487 }

what r the stages mostly used in realtime scenarios

Answer

these are mostly used in real time scenario:
database stages are:
1.oracle enterprise
2.tera data
3.db2
4.odbc
file stage are:
1.sequencial file stage
2.dataset
3.file set
4.hash file stage
processing stage are:
1.transformation
2.sort
3.modify
4.copy
5.funnel
6.lookup
7.surrogate key
8.join
9.aggregater
10 funnel stage
11.merge stage
12.Change Capture
13.Filter

debugging stage are:
1.head stage
2.tail stage
3.peek stage

Question { Cap Gemini, 13476 }

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

Answer

Hi this is Poorna ,

We can Improve the performance on join stage by doing
pre sorting for both left and right data based on
key .Then we can Improve the performance in join stage .

Plz correct me if any mistake in thinking .