Answer / bharath

It is not possible to generate alphanumeric surrogate key
in datastage.

Answer / datastage4you

You can generate AlphaNumeric surrogate key but not in surrogate stage, You need to put your logic in transformer

thanks
www.datagex.net

Answer / dhana

Only a primary key can be alphanumeric and the surrogate key is etl generated key and it cannot be alphanumeric and it is only numeric.

How can u execute the sql query through unix? What is the Primary key for Dimension table? what is the primary key for Fact table?

5 Answers   TCS,

---

What steps should be taken to improve Datastage jobs?

0 Answers  

---

What is Cleanup Resources and when do you use it?

2 Answers  

---

What is exact difference between Parallel Jobs and server Jobs..

7 Answers   IBM,

---

1.i have 5 jobs(1-5),i connect with each other,i want run from 3-5 only how? 2.how to schedual the job in datastage7.5 2? what is the deff bet grip and fgrep command? how do you cleanse the data in your project

1 Answers   Accenture,

---

---

1.what is materialized data? 2.how to view the materialized data?

0 Answers   HCL, IBM,

---

Wat is isolation level and when do u use them?

1 Answers   HP, IBM,

---

Explain the ChangeApply stage?

11 Answers  

---

in datastage scenario this is sourec data i want this traget? tell me please? source target ------- ------- Mohan,Prasad,Naresh Mohan Prasad Naresh

1 Answers   IBM,

---

Hi All, Could you please let me know whether Datastage server and px supports oredb? OREDB:It's a Oracle Retail Embedded Database.Previousely It was called as Acumate data base. It's a multidimensional database. Please help me on this issue ASAP. Thanks in advance Ashok

1 Answers   Accenture,

---

what is A Datastage?

2 Answers  

---

How do u call shellscript/Batch file from DS?

4 Answers   HP,

---