Answer / brajesh kumar

In most of the cases we dont have the required data in one
schema and it should nt be if its not of same level of
importance. comming to ur question,we can 2 cases:
1. if both schema are present in same database instance.
2. if both schemas are on different database instance.
for 1. we can access data from any schema via sql query
within dtabase connection stage on datastage. the sql
structure wud be according to the required output.

for 2nd one. we need to use 2 database stage and then via
join or other database filter stages u can get ur desired
output.

Answer / nish

since you know the schema already use the modify stage and also make sure that RCP is enabled.
This will help you ensure you get the columns you need.

What are constraints and derivations?

0 Answers  

---

How do you generate sequence number in datastage?

0 Answers  

---

Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...

0 Answers   UHG,

---

can any one tell me how to install datastage 8.1 in windows xp with wizard

2 Answers  

---

What a datastage macro?

0 Answers  

---

What is difference between join, merge and lookup stage?

0 Answers  

---

What are iconv and oconv?

0 Answers  

---

i have data like sam ram sam raj ram I want two targets trgt1 ram sam trgt2 raj how can i do this in datastage?

4 Answers   IBM,

---

why do u need the IOS upgradation in a FC switch

0 Answers   IBM,

---

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,

---

what is normalization and denormalization

2 Answers   CTS,

---

Hi This is Vijay, How can your remove the duplicates in sequential File?

15 Answers   HCL, Scope International,

---