Answer / Mukesh Kumar Rahul

A DataStage Macro is a reusable piece of code that can be called from multiple places within a DataStage job. It simplifies the development process by allowing developers to create and use common functions, transformations, or error handling logic across various jobs.

What is the command line function to import and export the ds jobs?

1 Answers  

---

how may datastage variables/parameters will be in trnsformer stage? 1 2 3 4 ?

1 Answers   Wipro,

---

j1,j2,j3 jobs r runing iwant to run j1,j3 after j2 how to do this using sequencer? 2)j1,j2,j3 jobs r runing iwant to run j1,j2,j3 how to do this?

1 Answers   Wipro,

---

In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?

1 Answers  

---

What is the use of surrogate key stage?

2 Answers  

---

Difference between sequential file and data set?

1 Answers  

---

Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also

1 Answers  

---

what is the Difference Between Datastage Server Edition and Parallel Edition?

2 Answers   Tech Mahindra,

---

hi, 1)totally how many jobs created in ur project 2)what is ur datamart size & Dwh size 3)How secure ur project 4)could u plz tell be about testing process after complete the job will run sucessfully or not in Datastage

1 Answers   Wipro,

---

Is possible to create skid in dim,fact tables?

1 Answers   NTT Data,

---

What are the environmental settings for data stage,while working on parellel jobs?

2 Answers   Satyam,

---

I have the following columns in the EMP table Empid,Empname,Sal,month(Sal),year(Sal) and DOB(let us say the dob is 15th-Jan-1981) Desing a job such that the output contains the following empname,year(sal),tot(sal) and current age i.e. whether 18yrs or so on

1 Answers   Accenture,

---