Answer / Alok Deep Satwalia

The Datastage job can be imported using the dsimport command and exported using the dsexport command. For example, to import a job named 'my_job', you would use 'dsimport my_job' and to export it, you would use 'dsexport my_job'.

how to delete one row in target dataset

1 Answers   Satyam,

---

when we will use connected Lookup & Unconnected Lookup

3 Answers   Wipro,

---

Hi, I am getting data from sequential file like below column1 A&B C&D A&E X&Y&Z v&x But I need the target column as like below column1 A and B C and D A and E X and Y and Z v and x

7 Answers  

---

HOW CAN WE SEE THE DATA IN DATASET?

12 Answers   IBM, TCS,

---

how to unlock a locked job in datastage 8.0

3 Answers   HCL,

---

What is Horizontal transformation, vertical transformation,diagonal transformation?

2 Answers   Cap Gemini,

---

What are the main differences you have observed between 7.x and 8.x version of datastage?

1 Answers  

---

Give an idea of system variables.

1 Answers  

---

What is usage analysis in datastage?

1 Answers  

---

What is the use of hoursfromtime() function in transformer stage in datastage?

1 Answers  

---

Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.

1 Answers  

---

diff between OLTP and OLAP? what TOP-DOWN and BOTTOM-UP Approach? which is best? what are Star Schema and Snow Flake Schema?

2 Answers   TCS,

---