Hi, My source is oracle(eno,ename,sal,commision,...), my requirement is like this, if there is a null values in commission col i want to keep it as null,and for the remaining first two characters of the value in my target. Plz help me

1 Answers  

---

Why do you need stage variables?

0 Answers  

---

i have 3 diffrent tables. 1) US rate data 2)CANADA rate data and 3)MEXICO rate data. All 3 tables have 6 collumns each. 4 collumns are commun to all tables and 2 are diffrent. Now at target i want single table say Country rate which will have (4+2+2+2+1 flag) 11 collumns. I will add a flag collumn which will indicate country and will put nullable collumns which are not common to other. How i can implement this in datastage?

1 Answers   ABC,

---

What is a quality stage in datastage tool?

0 Answers  

---

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

4 Answers   IBM,

---

If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?

0 Answers  

---

i/p o/p1 o/p2 1 1 4 1 1 5 1 1 6 2 2 2 2 2 2 3 3 4 5 6 how to populates i/p rows into o/p1&o/p2 using datastage stages?and also the same scenario using sql?

8 Answers   IBM,

---

What are constraints and derivations?

0 Answers  

---

There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this

5 Answers   IBM,

---

What is APT_DUMP_SCORE?

2 Answers   IBM,

---

Tell me the syntax of Configuration file?

1 Answers  

---

how do u catch bad rows from OCI stage? And what CLI stands for?

0 Answers  

---