Answer / jack

You can invoke shell script through Job Properties -->
Before Job routine --->ExecSH

Answer / vaishali

using execute command stage

Answer / datastage4you

there are diff ways to call..

if Seq job :
Use command stage to call a shell script

or if job
go to the job properties and select "Before/After job
routine" and use ExecSH options to invoke shell script.


Thanks
http://datastage4you.blogspot.in/

Answer / kiran

Well answer from Jack and u can call from another way.go to
Job Properties and ther r one option is ther like
APT_CONFIG_file Tab is there do to user defined and select
Search Shell Path

How can i approach to write datastage 7.5 Certification? and how much they will charge for examination .What exactly should i do? Can anyone guide me plz?

2 Answers  

---

What is configuration your file structure 2)I have two databases both are Oracle while loading data from source to target the job takes 30 min but I want to load less time how?

1 Answers   Hexaware,

---

what is factless fact table?

3 Answers   IBM,

---

Hi, My source is oracle(eno,ename,sal,commision,...), my requirement is like this, if there is a null values in commission col i want to keep it as null,and for the remaining first two characters of the value in my target. Plz help me

1 Answers  

---

SEQUENTIAL FILE I HAVE ONE RECORD,I WANT 100 RECORDS IN TARGET?HOW CAN WE DO THAT?PLS EXPLAIN ME AND WHAT STAGES ARE THERE?WHAT LOGIC?

1 Answers   TCS,

---

Source contains the metadata source ----- hyderabad,chennai,bangalore by using nested loop sequence select source as hyderabad in target just run target as hyderabad only not others please give me answer thanks in advance(give reply how to wrote logic using nested loop sequence)

1 Answers   IBM,

---

Hi am sundar, i have datas like 00023-1010 00086-1010 00184F2-1010 . . . . SCH-AS-1010 200-0196-039 . . . Now i want the result "SCH-AS" in onee column and "1010" in another column.. Can any one tell the answer...

5 Answers  

---

How can we perform 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?

1 Answers   Infosys, TCS,

---

table a contains 5 columns and table b contains 5 columns how can i get 10 columns at target?

9 Answers  

---

Hi all, explain one complex business rule that you had in your project and how did you accomplish it using DS?

1 Answers   HCL,

---

1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?

0 Answers   IBM,

---

how can we send even and odd records from a sequential file to two different targets

10 Answers   IBM, iGate, TCS,

---