Hi friends,Two input files, wants to validate only if the reference data has '0' otherwise no validation should be done..how to do this??

1 Answers   IBM,

---

When we will go for Data elements?

3 Answers   TCS,

---

If you want to use the same piece of code in different jobs, how will you achieve it?

0 Answers  

---

what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees

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,

---

Is there no issue when you try to convert a NOt null column in nullable and vice versa in aggregator styage and transformer stage? When I tried i got the warnings but in a running code I can see such type of scenarios. Please explain

2 Answers  

---

Whats difference betweeen operational data stage (ods) and data warehouse?

0 Answers  

---

what is use of SDR function?

0 Answers   CGI,

---

how to change left and right links in join stage?

4 Answers   Cap Gemini, IBM,

---

What is the difference between account and directory options ?

0 Answers  

---

Hi frnds, my scenario is like i'm having a record 1234"1323£3434%343434^23232!1212$23232 in the above record all the special characters must be removed.how can we do it in datastage 8.0.1.can any one please ans this? thanx in advance

2 Answers   IBM,

---

when u face critical situation in ur project, how to solve them?

1 Answers   Toyota,

---