How to convert alpha Numeric values to alpha using functions?

1 Answers   CTS,

---

how can we create tables in datastage?

1 Answers  

---

what are fact tables and dimension tables? give example assuming one table.

3 Answers   IBM,

---

root tree will find which is server job and which is parallel job?

0 Answers   IBM,

---

what is the difference between INROWNUM AND OUTROWNUM IN DATASTAGE SERVER EDITION?

2 Answers  

---

Wat is isolation level and when do u use them?

1 Answers   HP, IBM,

---

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?

0 Answers  

---

My source having following data as below, AB1 Aim2 Abnv5 1An8bx and my question is i need the Datastage job the following as in my target 000AB1 00Aim2 0Abnv5 1An8bx Please help me to achive this.

6 Answers   Wipro,

---

A job is having only 2 stages I/p dataset and target table.Job is taking very long time to load 50 million records.How to improve performance of this job.

3 Answers   IBM,

---

What is confirmed Dimension? what is Factless Fact? give one example? What are Additive, Semi-Additive Facts?

1 Answers   TCS,

---

What is the differentiate between data file and descriptor file?

0 Answers  

---

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

2 Answers   Satyam,

---