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.

1)i put Pharma Project in my Resume..whar are the sources used in my project Generally? 2)how many fact and dimensional tables used? 3)Have u used any Datamarts and measues in fact table? ....plz give the answers...

2 Answers   iGate,

---

if 3 table having different columes. like first table having 4 columns , second table having 3 columns and third table having 2 columns then how to capture the data by using funnel stage in parallel jobs...srinu.thadi

17 Answers   IBM, TCS,

---

we run a job in 4 nodes,i want to run same job on 8 nodes is it possible? job recompling is mandtory?why?

1 Answers   HSBC, NTT Data,

---

describe the Steps to confiure a Qlogic switch

0 Answers   IBM,

---

Whats difference betweeen operational data stage (ods) and data warehouse?

0 Answers  

---

how to clear the source file? 2) diff b/t odbc & Oracle?what is node? 3) explain one complex job u face in ur project

2 Answers   Wipro,

---

how to cleansing data

6 Answers   Cap Gemini,

---

What is audit table?

1 Answers  

---

specify data stage strength?

1 Answers  

---

how to convert rows into columns

2 Answers   IBM,

---

How many types of stage?

0 Answers  

---

difference between function and procedure...

1 Answers   IBM,

---