there are two schemas x and y are there. some data is in x schema. i want to us

there are two schemas x and y are there. some data is in x
schema. i want to use that in y schema..how can i use?
please give some possibilities

Question Posted / raja

2 Answers
7277 Views
Wipro, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

there are two schemas x and y are there. some data is in x schema. i want to use that in y schema....

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.

Is This Answer Correct ?

8 Yes

1 No

there are two schemas x and y are there. some data is in x schema. i want to use that in y schema....

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.

Is This Answer Correct ?

0 Yes

2 No

Post New Answer