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.

How to remove duplicates in transformer stage? in parallel mode

6 Answers   Syntel, TCS,

---

in source is like seq file in date column have dd-mm-yy dddd-mmmm-yyyy mm-dd-yy yy-dd-mm yy-mm-dd i want to display only yy-dd-mm date formats only in tgt?

2 Answers   Wipro,

---

what is the use of skid in reporting?

0 Answers   NTT Data,

---

how to write server Routine coding?

0 Answers   Eric,

---

I have 5 different sources i want same records in 5 different targets Can you any body send me this question answer rathdsetl@gmail.com

2 Answers   TCS,

---

Which commands are used to import and export the datastage jobs?

0 Answers  

---

how does work server jobs?

1 Answers  

---

WHAT IS FORCE COMPILE?

3 Answers   FIS, HCL, Polaris,

---

i have a scenario in which i/p columns areID,salary with 1,1000 2,2000 and 3,3000 i need an extra column in the o/p named avg(salary)how can i get it?

4 Answers   L&T,

---

whom do you report?

0 Answers   NTT Data,

---

LIST THE BUILT-IN STAGES AVALIABLE IN SERVER JOBS?

2 Answers   Mannar Company, ME,

---

I WANT TO SEND SYSDATE AS PARAMETER,SO WHAT COMMAND I SHOULD USE TO CALL SYSDATE?

4 Answers   ME,

---