Answer / chandu

some companies using shell script to load logs into audit table or some companies load logs into audit table using datastage jobs.these jobs are we developed.

Answer / datastage4you

Now, for auditing Datastage jobs, you can use Operation Console database ODB to fetch the same details easy way

Thanks
www.datagenx.net

how to retrive the max(sal),deptno,empno in datastage?

13 Answers   Polaris,

---

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  

---

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  

---

i have source data like empno,enmae 11 ,aa 12 ,bb i want output like empno,ename 11 ,aa 12 ,bb 11 ,aa 12 ,bb

7 Answers   TCS,

---

Can you filter data in hashed file?

0 Answers  

---

how to sort two columns in single job in datastage.

1 Answers   TCS,

---

what is the definitions for Datawarehose and Datamart?

4 Answers  

---

I have Seq file, I don't want 10, 11th(or any two records like 20, 30th records ) records in the output

6 Answers   TCS,

---

Hi dude, i/p eno ename date edate deptno 1 x 10thjuly 30july A 2 y 10th aug 30 aug B 1 x 1aug ------ A 3 z 1jan ------ c 2 y 1sep ------ B o/p is eno ename date edate deptno 1 x 1aug ------ A 2 y 1sep ------ B 3 z 1jan ------ c Here edate is System generates we don't know that value. Please design the job by using SCD stage and Sql query. If any body know this answer please tel me. Tanks.

1 Answers   Amdocs,

---

how to run jon in unix back round process what is command use in runing a job?

2 Answers   HSBC,

---

how CAN we remove duplicates in dataset?

2 Answers   IBM,

---

What is the version control how can i apply this in DataStage can any one tell me the anser

4 Answers   IBM,

---