Answer / suresh r angadi

you can call in the following places in ETL(DataStage)

1-Sequential File Stage (Stage->Stage Uses filter commands).
2-Before and after Stage Subroutines in Job Paramametrs tab.
3-Before and after Stage Subroutines in Transformer stage.
4-Job Sequences using Execute command Activity and Routine
activity.
5-Using DataStage Routines
6-Using Routines called ExecSH and ExecSHSilent

Answer / maruthi

IN MANY PLACES IN DATA STAGE YOU CAN USE UNIX COMMNDS.
Eg.)1.)IN SEQUENTIAL FILES CHECK FILE USES UNIX
COMMANDS,LATER U CAN GIVE UNIX COMMANDS AS FILTER,AND SO
MANY IN SEQ FILE SIDE TO FILENAME.
2.)IN BEFORE/AFTER SUBROUTINES U CAN SELECT EXEC SHELL
COMMAND AND U CAN GIVE UNIX COMMANDS TO CREATE FILES/DELETE
FILES.
SO MANY EG ,GO THROUGH THE HELP FILE.

when we have to go for a sequential file stage & for a dataset in datastage?

1 Answers  

---

how to handle null values in sequential file?

1 Answers   HCL,

---

You enter values in a schema file for RCP and you also entered values in sequential file? which one will it take?

1 Answers   TIAA CREF,

---

Define orabulk and bcp stages?

0 Answers  

---

How do you design PX Routines ?

1 Answers  

---

Define APT_CONFIG in Datastage?

0 Answers  

---

What are the different options associated with dsjob command?

0 Answers  

---

source contains 2 columns comes to target 4 columns how

1 Answers   IBM,

---

What is exact difference between Parallel Jobs and server Jobs..

7 Answers   IBM,

---

my source seq file have col1 1 2 3 4 5 6 7 8 9 i have 4 targets t1 t2 t3 t4 1 2 3 4 5 6 7 8 9 like this how we can get?

10 Answers   Polaris,

---

1)How to do error handling in datastage? 2)Did sequential stage accepts .xl files ,xml? znd how?

2 Answers   UHG,

---

what is A Datastage?

2 Answers  

---